Userform ComboBox

Sinbad

Board Regular
Joined
Apr 18, 2012
Messages
224
hi all,

any idea how I can read info form a sheet called "users" range a2..a30 for example and have them in the combobox.. now here comes my problem..

I need to be able to add a new user by just typing in the name into the combox and have this value saved to the list of users for future availability. The userform fills another sheet called "orders" but don´t think that has any impact to my userlist sheet

so next time the userform is called up it needs to rad a2..a31

I´m lost.. no idea how to achieve this. I can fill it with a static list, get the data into the orders sheet.. but the dynamic adding of users has me boggled...
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Sinbad

Board Regular
Joined
Apr 18, 2012
Messages
224
a nice variation to this would be if the "new" user is typed in that a userform pops up where all details could be entered .. ege tel no, adress etc ?? is that possible ?

Current code to fill the combobox:

Code:
Dim UG As Long
Sheets("Users").Select
UG = Range("A65536").End(xlUp).Row
Me.ComboBox1.List = Range("A2:A" & UG).Value
Sheets("Orders").Select
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,133,264
Messages
5,657,715
Members
418,410
Latest member
CrishFergus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top