So I have a Userform named "TimeStamp" with a combobox2 that I would like to populate based on this criteria. If the user logged into the workstation is equal to Sheets("All Staff").Range("D:D") the pull the names in .Range("G:G") as the options in ComboBox2! Any help would be greatly appreciated and I have attached my sample book to show you what I am trying to do!
This might help you.
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.
So I am using the code you are using above with a small change:
Is there away we can change that as the computer name is the name of the supervisor (ie. Ray Webber), however as you can see, the list of supervisors in column D on the All Staff sheet has it formatted as Webber, Ray. What would I need to change for this to work? All of them are on winTerms (Server based machines) so it runs off the network and that is how our machines are identified. Thank you so much for your help!Please Login or Register to view this content.
You can try this.
Please Login or Register to view this content.
I tried this code however now it is not populating any combo boxes
Try this and you'll see it works.
This shows that there's somthing wrong with yourPlease Login or Register to view this content.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks