I have the name of a control ("FormName.XControl") stored in a memory
variable (YVariable) I want to set the row source of xControl by referring to
the variable YVariable.
Instead of FormName.xControl.RowSource = ListName I want

I have several worksheets each containing similar information about
different clients and once a fortnight I am expected to send a report on all
activity. To do this I need to collate the information on a daily basis from
each worksheet then present it in the report as a total of ...

Hi - I have some radio/option buttons inside a group box which is then
all grouped together and locked in place.
I want to be able to (use VBA) to change the option button text.  When
I record a macro and then try and rerun it with different text, I get

I’m currently using a macro to get a table from one spreadsheet and place it
in another, then directly underneath this I need to insert another table. I
have this macro in place but the tables will have a different amount of  rows
each time I need to perform the macro. What macro ...

I’m trying to use a macro to get a table from one spreadsheet and place it in
another, then directly underneath this I need to insert another table. I have
this macro in place but the tables will have a different amount of rowes each
time I need to perform the macro. What macro ...

I have posted the question with the same subject and similar content to
microsoft.public.vc.mfcole . There I was said that my problem appears to be a
bug in Excel. I was suggested that I could post the mail here also. I got no
response from MS since then and when I try to contact ...

Hi this is a real newbie question but i've trawled the net and cant
seem to find a solution.
I'm trying to write a macro to rename image files and move them to a
new folder. I have a spread sheet with two columns, one product code

In response to a change in the background color of a cell, I would like to
enter a value into another cell. While I would prefer to the standard
conditional cell formating feature, I would also use VBA or a function to
solve my problem. Any help would be appreciated. Thank You, ...

I am looking for some videos on VBA training. Anyone knows of some good ones?

when i copy a formula to a range of cells the formula logically
changes according to the other cells. However, i need to maintain the
very same formula throughout the range of cells . i am able to
successfully paste the same formula to a single cell, but not to a

I placed a textbox on my worksheet using the drawing toolbar, and
would like to limit the number of characters that can be entered.  As
of right now the textbox allows the user to input more characters than
it can actually display.  Does anyone know how to limit the number of

Is there a registry location or .ini file entry or some other way for
me to define at startup where on the screen Excel (or any other MS
product) is positioned when it starts?
Here is the prob. At my docking station, I have an external monitor,

Is there a way to set the position of a message box when it opens like you
can do with an input box?
Richard.

Is there a method to test cells to determine their format patterns?

I created a commandbutton that calls a routine to print x number of
copies of a selected sheet based on the value of a specific cell.
My problem is that when I change the value in the cell, I have to
click elsewhere or press enter before I click on my commandbutton in