LinkBack URL
About LinkBacks
I need to add the below code to another code but I don`t know how. I tried End With in various locations but I have had no luck.
Can you assist please?
Please Login or Register to view this content.
I need to add the below code to another code but I don`t know how. I tried End With in various locations but I have had no luck.
Can you assist please?Please Login or Register to view this content.
Last edited by chin67326; 12-23-2015 at 07:16 AM.
It might be easier if you attached the workbook with the userform in it.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Examples for combining a listbox selection to the code too?
Last edited by chin67326; 12-23-2015 at 07:18 AM.
Anyone had a chance to review Chin's question further yet?
Thanks!
Do you think that this a difficult task?
Last edited by chin67326; 12-23-2015 at 07:18 AM.
The easiest method to retain the last listbox selection is to just hide the userform instead of Unloading it.
Then the next time you show it (within the same session), all the control's last states are retained.Please Login or Register to view this content.
2.) The code doesn't qualify a worksheet within the database. It defaults to whatever the active sheet is when the database workbook is opened. Since your example database workbook only has one sheet, it can't go wrong.
This syntax would qualify Sheet3 by name (if it had a Sheet3).
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thanks AlphaFrog! That makes sense!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks