I have found and modified the following code to insert a row based on a combobox value.....the issue is it inserts it below all examples of this value in the database. I only want it to find the last example in column "B" and insert a new row below that.
Any help would be greatly appreciated.
Please Login or Register to view this content.
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.
This should be much faster.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thank you for the attemted help.....This actually inserts a row for each example of the combobox value at the end of the last example. So for example if there is 7 "A's" in column B it inserts 7 rows after the last "A" in Column B. I just want it to find the last "A" (i.e. prentending that "A" is the combobox value) and insert 1 row with the same format.Originally Posted by mehmetcik
What happens with...
Please Login or Register to view this content.
Last edited by WasWodge; 06-26-2017 at 08:02 AM.
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
Unfortunately nothing but after reviewing a few times I can't figure out why as it seems to mirror what I was looking for. When I assign it to the commandbutton on the userform it does not do anything.
Hi,
Did you try the code in post #2? It appears appropriate for what you asked for.
Don
Please remember to mark your thread 'Solved' when appropriate.
Remove the quotes
Please Login or Register to view this content.
Did you try it before or after the edit when I realised that you were putting "UserForm1.ComboBox1.Value " as a string when it shouldn't be? by your reply I say before.
Thank you for the response....I have tried post #2 but similar to post #5 when I apply it to the commandbutton in the userform it does not seem to do anything at all. I am currently evaluating to make sure that I there is not any naming issue but the combobox is as stated in the code.
For context of this post this was the correction that was needed......in which WasWodge fixed in Post #5. This update was exactly what I was looking for and I want to say thank you to both of you for your assistance on this. My apologies for any confusion as sometimes I catch things in the midst of others posting. I will marked as solved and again just wanted to reiterate my appreciation for the help.Remove the quotes
Please Login or Register to view this content.
Jared
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks