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...
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...