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!
Reply With Quote