Programming

Unable to change security setting from "High" after reinstalling E
Good morning - hope this is considered to be the correct forum on which to post this! The message subject really says it all - I have reinstalled Excel after having to rebuild my PC and now can't run any macros, as the security setting is set to "High". Even when I set it to "Medium" or "Low", it's still sets ... 17 Jul 2008 10:38

Pattern/trend analysis against dates
Hi - I have a record of employees lateness and sickness on a spreadsheet, against a date. Is there any VBA or analysis addins that I could use to look at the dates of lateness/sickness in the cells, and advise if there is any trend (eg. last Friday of each month, Monday after payday etc). Just something basic ... 17 Jul 2008 06:31

PLEASE CAN ANBODY HELP
Hi all , I have macro (see below) from which I am taking sort of work of progress bar and it works fine Macro 1 ================================================> Public RunWhen As Double Sub StartBlink() If Range("N4").Value = "UPDATING PLEASE WAIT." Then Range("N4").Value = "UPDATING PL... 17 Jul 2008 12:42

checkbox and textbox help needed
1. i got 4 checkbox in a frame. when a user click commandbutton1 i need it to check if checkbox1.value = true then print sheet1 if checkbox2.value = true then print sheet2 etc through to checkbox4 2. when user click commandbutton2 i need it to check if textbox1.value = "user2". if it does i need sheet6 unp... 17 Jul 2008 04:28

vlookup with a variable
hello please help. in vba, i have the following statement ActiveCell.Formula = "=VLOOKUP(" & sRef1 & " & d2,Sheet6!f:i,4,FALSE)" actually, what i want to do is to encapsulate the variable sRef1 with inverted commas. e.g. the variable value is A. so my lookup value is "A"&D2 does that make sense? if so ho... 17 Jul 2008 05:30

How to add list item to a listview with optimize performance
Hi i am having 1 million database records, i would like to populate those through listview. I am using VBA Userforms, List view is drawn on it. Add item method of list view takes long time to populate these records. Please suggest faster way to populate in List View. I dont have any other control available to... 17 Jul 2008 03:27

VBA string funcs on left side of assignment?
Empirically I learned that the VBA function Mid() can be used on the left side of an assignment. For example: s = "12345678" Mid(s, 4, 2) = "cd" results in "123cd678". But the following does not work: Left(s, 2) = "ab" Right(s,2) = "ef" Then I looked at the Help text for Mid, and I found nothing that ... 17 Jul 2008 04:28

Comparing and Reconciling 2 excel tables.
We regularly receiving inventory update .And it is a huge list. Question 1 : how do we compare and reconcile the previous inventory xcl table (OldInv)) with the new inventory update xcl table(NewInv) so that we could figure out which sku is new in NewInv and was not present in OldInv? Question 2: how do we c... 17 Jul 2008 07:32

resizing a Combo Box
Hi, all: I have a Combo Box (View\Toolbar\Form). The size of this combo box is 1" (Height) and 3" (width). There are two items for the combo box's input range. However, one of the item is too long such that when I click on the combo box, this item is not fully visible. Is there any way to resize this combo box... 17 Jul 2008 08:34

Inserting Image based on cell value - Help
Hi everyone I am trying to create a macro that will look at cell values in range A1:A2 in sheet1 and insert the correct image on B1:B2. I.e. values are 2 letters (either number of alphabet e.g. 2C, TH), image files are value.gif (e.g. picture for TH = TH.GIF) Path for those pictures are C:\My Documents\ but... 16 Jul 2008 21:18