Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transfering Declared value through procedures
Hello group,
I have a combobox in which I declared the combobox.value once the drop down is selected I want it to store the .value and other values between sub procedures. How do I make it the procedure remember what has been declared in the past decided values. Thanks in advance. Regards, Fish |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transfering Declared value through procedures
Fish,
Either write each of the values to the registry, to a custom workbook property, or a cell on a sheet. HTH, Bernie MS Excel MVP "FISH" wrote in message ... Hello group, I have a combobox in which I declared the combobox.value once the drop down is selected I want it to store the .value and other values between sub procedures. How do I make it the procedure remember what has been declared in the past decided values. Thanks in advance. Regards, Fish |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transfering Declared value through procedures
Fish,
I'm sorry, I think I mis-interpreted your question. If you use global variables, then you can store the values while the project remains open. Global myString As String for example, which must be at the top of your code module. HTH, Bernie MS Excel MVP "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... Fish, Either write each of the values to the registry, to a custom workbook property, or a cell on a sheet. HTH, Bernie MS Excel MVP "FISH" wrote in message ... Hello group, I have a combobox in which I declared the combobox.value once the drop down is selected I want it to store the .value and other values between sub procedures. How do I make it the procedure remember what has been declared in the past decided values. Thanks in advance. Regards, Fish |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference a variable declared in VBA | Excel Worksheet Functions | |||
Macro for autofilter using variables declared in worksheet | Excel Worksheet Functions | |||
VBA Sub procedures | Excel Programming | |||
Can Not Find declared dll | Excel Programming | |||
VBA -- procedures as arguments? | Excel Programming |