pasj
06-19-2013, 12:53 AM
Hi guys!
Hopefully you can help me with these problems. I'm having some trouble with my VBA project.
Atm I have a excel spreadsheet with some labels (weeks and cities, x,y) and lots of data to represent sales in the particular week and city.
I would like a combo box to list all the cities in the spreadsheet (they are all listed in the 1st coloum of the sheet).
EDIT: I have added the combobox with .additem "" - a better solution is of course welcome!
Furthermore i would like 2 textboxes to list additional data (where i can put in sales for the city i chose in the combo box) and a button which put in the data from the text box into the sheet in the right place!
I have a button now that adds a new week to the spreadsheet so that part is covered!
If dont understand the questions please reply.
Thans in advance for your help!
Hopefully you can help me with these problems. I'm having some trouble with my VBA project.
Atm I have a excel spreadsheet with some labels (weeks and cities, x,y) and lots of data to represent sales in the particular week and city.
I would like a combo box to list all the cities in the spreadsheet (they are all listed in the 1st coloum of the sheet).
EDIT: I have added the combobox with .additem "" - a better solution is of course welcome!
Furthermore i would like 2 textboxes to list additional data (where i can put in sales for the city i chose in the combo box) and a button which put in the data from the text box into the sheet in the right place!
I have a button now that adds a new week to the spreadsheet so that part is covered!
If dont understand the questions please reply.
Thans in advance for your help!