getting a worksheet from a combo box.
Hi,
I have a form (Data_Input) on this form I have 2 X Combo Boxes ( CMB Name & CMB Team).
When I press the enter button I want to go to the worksheet selected in CMB Name, then find The team in Column "N" that is from CMB Team.
I then want to add data so I will Offset this.
Many thanks
Fast answers need clear examples.
Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
As JohnTopley wrote above, but you can try the following scheme:
User form module
Please Login or Register to view this content.
Stat trial.xlsm
Not sure if it has attached?
It looks a bit messy, just need the code then I can tidy it up.
Cheers
John
I suppose you meant Column B because Column N is empty.
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.
Your comboboxes are populated with non space names and the actual sheet names have spaces and vice versa for Team names
So fix that up and then this can be adapted to work...Adapting from bakerman2
I also...personal preference...keep all controls at default names...so much easier to manipulate and loop through if needed...
Is a nightmare having to remember each individula control name...
Please Login or Register to view this content.
Last edited by Sintek; 11-01-2024 at 01:38 PM.
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
Hi Sintek,
The values are not coming across as a Number, it wants me to change them to a number manually (Long Job), is there anyway this can be done using VBA?
Sorry to be a pain.
Cheers
John
Please elaborate...I have no idea what you mean...Hi Sintek,
The values are not coming across as a Number, it wants me to change them to a number manually
When I put a number into a textbox on the form, it shows on the worksheet as a number with the green triangle in the corner, I then have to click on it to transfer to a number.
I dont know what your code snippet is but my guess...Add the red snippet as the content of a textbox is always a string...
Please Login or Register to view this content.
Last edited by Sintek; 11-03-2024 at 08:34 AM.
Sintek.
I new it was that easy.
Many thanks
John
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks