I thought I'd find this by searching the forum, but no luck. In my userform, I import a bunch of data that may or may not be valid. I use checkboxes so the user can click if the data is valid, all the controls become unlocked and ungreyed, then edit it as necessary. But I really dont want to beleaguer my module with 20 of these checkbox macros. Isnt there a way to apply one macro to all checkboxes in a userform? Thanks. -Luke
HTML Code:
Never mind. I'm a stoopid fat dummy. I just did a function call for the checkboxes.
To keep it simple.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Yup. Worked like a charm. Thanks.
Had to change data.Frame1 to Me("frame" & nmbr) also.
Looks so much cleaner.
-Luke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks