passing a variable to a macro
Posted by Kelly on August 31, 2001 6:55 AM
I've recorded a few macros in Excel, and am now starting to get into the Visual Basic side of things. I would like to pass a variable in and out of these macros, in this particular case macros describing combo boxes.
In my very limited knowledge, I've tried defining the variable at the start of the sheet code and changing the private sub macros to public sub or just sub, but still
Sub ComboBox1_Change(variable As Integer)
comes up with a compile error when I go back to Excel.
Could someone suggest what I am doing wrong, or perhaps suggest a better route?