I am attempting to write a simple basic userform with two comboboxes with select case to learn how it works before I add it to my extensive report.
This uerform has two comboboxes with submit and cancel buttons, that's it.
I wrote the code here, focusing on combobox 1 for now. (Combo box 2 will be added later).
After executing the code in immediate window, it says "Compile Error: Invalid use of property". I wonder why.
Formula:
Please Login or Register to view this content.
What code did you put in the Immediate Window?
That code should be in the Userfom module with one adjusment.
When I do that and run the form it works as expected, displaying the relevant message based on what's selected in the combobox.
Please Login or Register to view this content.
If posting code please use code tags, see here.
TestForm was what I put in the immediate window to run TestForm macro below:
Formula:Please Login or Register to view this content.
Not a good idea to name both the sub and the userform TestForm.
-______-
Noob mistake!!! HahaH Thanks, Norie!!
SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks