I've had some help from another forum that I shall not name but I stopped receiving replies. I just need to know how to call up a UserForm from Excel. I will attach the workbook I'm using and post all code here. Thanks in advance for any help.
The attached has this in the userform's code module
VBA:
Please Login or Register to view this content.
And this in Sheet 1's code module
VBA:
Please Login or Register to view this content.
Last edited by Blitskrieg; 05-21-2010 at 02:26 PM. Reason: Code syntax.
Put a commandbutton on sheet1 and assign the macro:
Please Login or Register to view this content.
Ben Van Johnson
Thanks for the reply. I was really hoping this was a last resort kind of option. Ideally the UserForm would be displayed when certain numbers are entered into the first column. Hence the Worksheet change piece of code. So when a number that for the example is listed in Column I, is entered into Column A, display my UserForm and bring the value of the combo box back two columns over.Originally Posted by protonLeah
Put a commandbutton on sheet1 and assign the macro:
Please Login or Register to view this content.
What's the point? Use Data Validation List
What's this line supposed to do,it wouldn't work without a selection being made?
Also,don't add error handlers until the code is workingPlease Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
This works great thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks