Problem in Variable Scope

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Try:

MsgBox Sheet1.cbovar

And use "Option Explicit"!

--

Vasant



vrk1 said:
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
Click to expand...
please?
 
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
 
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.
 
Back
Top