Programming

RowSource for my ListBox
Below is the RowSource I would like to use for the ListBox on my UserForm. Can this be done without actually opening the source document (EmployeeList.xlsm)? '[EmployeeList.xlsm]Employee_List'!$A$2:$Z$300 ... 15 Apr 2010 13:39

Start/End Cells in a Range
Hello all, Having issues with a range and my searching has turned up nothing. I'm probably missing something obvious, but I don't feel like beating my head against the wall anymore. I have a Range object. I'd like to get the row/column values for the start and end cells of the range. The range is 'Raw Da... 12 Apr 2010 13:41

Textbox object event - Help please
HI Everyone... I've been struggling with this for awhile and still don't understand why this won't work. Any help in making it work would be appreciate... 1. Code adds frame containing textbox with events for the textbox to worksheet. This works. 2. Class changes text property of textbox to "aaa" when te... 13 Apr 2010 00:47

Please guide
Hi Please help on the following issue: I have to check if one of the check boxes in the following cells is checked I need a macro that checks if the check box in cell G14 (Check box 53) is checked in sheet Account Tracker. If its checked then I want to do the formula in G17, if the check box in H14(Check b... 13 Apr 2010 16:13

help needed
Hi Please help on the following issue: I have to check if one of the check boxes in the following cells is checked I need a macro that checks if the check box in cell G14 is checked in sheet Account Tracker. If its checked then I want to do the formula in G17, if the check box in H14 is checked I want to do th... 13 Apr 2010 15:06

Max length of variable name?
Hi, Sorry if this appears twice, could not tell if first posted. What is the maximun length of a varaible name? x=1 not problem, but xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx=2 this is too long, yes? How long can it be? Thanks, -- David ... 12 Apr 2010 23:41

Message box shadow
I have a spreadsheet that when a macro displays a message box and one moves the message box by clicking on it with the mouse and dragging it across the screen it leaves a trail of hundreds of message boxes behind it. Does anyone know what causes this and how I can prevent this happening. -- with kind regards ... 13 Apr 2010 08:22

Excel Security
Greetings I'm currently trying to develop a 'solution' to deliver to my clients. I'm almost definitely going to be using Excel barring any showstoppers - since this is what my clients know best. I'm trying to avoid using VSTO, and would like to be able to stick with Macros and VB code within Excel. My big... 18 Apr 2010 19:45

Variable Range with a loop needed
Ok this is going to be long to explain. Spreed Sheet has 7 columns and an unknown amount of rows as a total so columns from A to G and Rows = unknown Colum definition A = Date B = Account # C = Type of Account D = Amount posted (on our system) E = Amount posted (on an external system) F = Date when it c... 12 Apr 2010 13:41

Type Mismatch
Hi All, I get the type mismatch error on this line of code TmpCB.Sheets("03-10").Cells(z, 2).Value = OldCB.Sheets("032010").Cells(x, 2).Value + " - " + OldCB.Sheets("032010").Cells(x, 3).Value I know that cells(x,2) at this poin in the code is "check run" and Cells(x,3) is "4277" I'm sure ... 12 Apr 2010 13:41