Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem in Variable Scope
I have a Combobox (cbovar) inside the Worksheet "Sheet1" I also have a
Submit button that calls a macro "Macro A" (Note: There are no Userforms here. The buttons are in the worksheet "sheet1".) The function of "Macro A" is to show the value of the combobox. sub macroa msgbox(cbovar) end sub The value shows up blank even when the combobox is checked on "Sheet1". How do I get the value of the combobox printed on the screen? I am having problem understanding "variable scope" ...Can anyone help me out here please? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem in Variable Scope
Try:
MsgBox Sheet1.cbovar And use "Option Explicit"! -- Vasant "vrk1" wrote in message ... I have a Combobox (cbovar) inside the Worksheet "Sheet1" I also have a Submit button that calls a macro "Macro A" (Note: There are no Userforms here. The buttons are in the worksheet "sheet1".) The function of "Macro A" is to show the value of the combobox. sub macroa msgbox(cbovar) end sub The value shows up blank even when the combobox is checked on "Sheet1". How do I get the value of the combobox printed on the screen? I am having problem understanding "variable scope" ...Can anyone help me out here please? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem in Variable Scope
That did not work. I am getting a Run Time Error message.
Maybe I am doing something wrong. Can you explain with a code please? Thanks "Vasant Nanavati" wrote: Try: MsgBox Sheet1.cbovar And use "Option Explicit"! -- Vasant "vrk1" wrote in message ... I have a Combobox (cbovar) inside the Worksheet "Sheet1" I also have a Submit button that calls a macro "Macro A" (Note: There are no Userforms here. The buttons are in the worksheet "sheet1".) The function of "Macro A" is to show the value of the combobox. sub macroa msgbox(cbovar) end sub The value shows up blank even when the combobox is checked on "Sheet1". How do I get the value of the combobox printed on the screen? I am having problem understanding "variable scope" ...Can anyone help me out here please? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem in Variable Scope
Is cbovar a ComboBox from the Forms Toolbar or the Control Toolbox? If the
former, you cannot directly retrieve its value; you have to look it up from the source range. -- Vasant "vrk1" wrote in message ... That did not work. I am getting a Run Time Error message. Maybe I am doing something wrong. Can you explain with a code please? Thanks "Vasant Nanavati" wrote: Try: MsgBox Sheet1.cbovar And use "Option Explicit"! -- Vasant "vrk1" wrote in message ... I have a Combobox (cbovar) inside the Worksheet "Sheet1" I also have a Submit button that calls a macro "Macro A" (Note: There are no Userforms here. The buttons are in the worksheet "sheet1".) The function of "Macro A" is to show the value of the combobox. sub macroa msgbox(cbovar) end sub The value shows up blank even when the combobox is checked on "Sheet1". How do I get the value of the combobox printed on the screen? I am having problem understanding "variable scope" ...Can anyone help me out here please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
variable scope | Excel Programming | |||
scope/ lifetime of variable | Excel Programming | |||
Variable Scope | Excel Programming | |||
Variable scope | Excel Programming | |||
Scope of Public Variable | Excel Programming |