Find next empty row in a range (add data via userform)
Hi. I'm trying to write some VBA to find the next empty row in a range and then add data via a user form. I need to be able to select Range via combobox and then type text in textbox below. After i click a button, the text is entered under the selected range. I have multiple ranges organized in columns.
If you want to find the next available row in column A for example - you can use this
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Are you listing named ranges?
If posting code please use code tags, see here.
Yes the Ranges are named. e.g. Fruits, Vegetables etc..
How would you write a code, so the user could select column A in combobox and the textbox would relate to that selection
What exactly do you have in the combobox?
Re: Find next empty row in a range (add data via userform)
Combobox lists one Range "Class". There are 14 Classes. They will show up in combobox. My worksheet has 15 columns, Column A is my Class Range, and the rest 14 are the Classes. They are all defined as different ranges. I must be able to select preferred Class from combobox and enter "Category" under that Class in my worksheet. How do i do link my textbox to combobox selection
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks