Hi,
I was woundering if there is possible to get a scrolldownlist from worksheet 2 collumn B to be linked up to textbox in a userform.
Best regards
喕stein
Hi,
I was woundering if there is possible to get a scrolldownlist from worksheet 2 collumn B to be linked up to textbox in a userform.
Best regards
喕stein
see large yellow banner - how to upload a workbook - far easier then to give you a concise solution.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
By "scrolldownlist" do you mean that have that you have a cell with data validation using a Dropdown List? You can link the cell to the textbox using the ControlSource property.
In the UserForm design screen, click on the textbox, hit F4 to show Properties, and enter the cell reference in the ControlSource field:
'Worksheet 2'!B1
where B1 is the cell reference
Thanks for youre reply,
I tested it, but couldent make it work, so now I have attached a samplefile.
In the userform I want a scrolldownlist in the textbox that says kunde. I have made a list from Sheet 2 collumn B and called it "Kunderegister", and this is the list I want to use in the userform.
Challenge number 2:
I have formulas in sheet A and B that blocks me from starting the registrating from the userform in row 4. I need to start the registration from row 4
I hope this was a god enough explanation for someone to help me solv this.
Best regards
Øystein Breivik
Sorry, not clear enough. A textbox cannot be a dropdown list.
I have taken a guess and modified your UserForm to use a combobox instead of a textbox, which makes most sense to me based on reading your code.
I have also updated the code to fix this reference.
Also, your named range Kunderegister uses the entire column B. This is bad. You should just include the used cells. I have modified the range to be dynamic.
No idea what you mean in "challenge 2"
Thanks for great help, the combobox workes perfect. The last problem that I still have is that it starts registering the data in row 27 because of the formulas I have in A and B 4 - 26. I need the registration to be started in row 4.
Hope the explanation is god enough
Thanks for all help so far.
Best regards
Øystein Breivik
Hello,
I see that my explanation could have been better
When I register the data from the userform in sheet 1, it should start in row 4 C to H. I have written some formulas in collumn A and B 4 - 26, so now it starts the registration of data in row 27. I need it to start in row 4 but also make it fill in the data in A and B as the formula is supose to do.
Hope that made more sense
Best regards
Øystein Breivik
Your code looks for the last used cell in column B (not the last cell with a blank value). You could pick another column. Is there another column that will always be populated when the row is being used?
Please Login or Register to view this content.
Thanks for fast reply,
I just changed it to C, so now it workes perfect. I missed that one when copying the code from another formula
Regards
Øystein Breivik
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks