Hi all,
I would like it so that on m userform, if i select a 'Unique ID' (eg. ID12), there will be a few labels below that will return data based on cells in the spreadsheet.
So for example, if i was to select ID12, i would like one label with the caption saying the date, another label with the process (eg, quotations) ect.
All of the data is in a spreadsheet..
Is this possible?
It would be great if attached sample workbook it will be very easy resolve your query
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Hi, thanks for your reply.
I have attached the spreadsheet...Turnback Status Checker.xlsm
hi,
add 3 labels to yr userform, let's say label6,7,8 and add this piece of code to yr combobox, hope it helps you!
Please Login or Register to view this content.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
Wow.... You sir, are a genius
Thank you very much for your help, i am very greatful - you have been a massive help.
Glad I could help you! Thx for the rep!
if you are happy with the solution provided, please mark the thread as "Solved"! thx!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks