Export to Excel Problem

[NickJ]

Hi guys

I have a combobox that the user selects a name (the Title) from, then the user moves across text from a listbox to 6 labels, the user clicks a button to export these to excel with the Title at the top (Cell “A1” and the text goes in A2,A3,A4…..)

My question is this,
How can I export another set of text using a different title (selected from the combobox) and have it exported to cell A6 and not Cell A1?

Thanks

Nickjs

 

[WannabePBA]

Maybe use a variable, and each time the user makes a selection in the combo box, add 5 to the variable. so your range statement would be:

range = sheet.range("A" & intCellNumber & ", Missing.Value)"