PDA

View Full Version : Help Whit Userform add and delete data Listbox!



Petter120
10-25-2011, 06:34 PM
Hello!
Im verry new whit this VBA thing and i hope someone can guide me in the right direction.

Im trying to create a Userform that includes:

TextBox1
TextBox2
CommandButton1
combobox1
Listbox1
CommandButton2



1. If i write value in TextBox1 och Textbox2.
2. If i chose Sheet1 or Sheet2 Combobox1.
3. and if i press Commandbutton1.

I want the value in Textbox1 and Textbox2
depending on what is selected in combobox1 to add it on first free row in the sheet that is selected in the combobox1.

Then im trying to get a the Listbox1 to show whats in sheet1 or sheet2
depending on what i select in the combobox1.

And as a last thing i want to beable to delete from the Listbox and the sheet whatever i select in the Listbox1 when i press the commandbutton2.

Tanx

Petter

Rob342
10-26-2011, 12:45 AM
Petter

How far have you got & can you post a copy of the workbook where you are now?