I have thought about different approaches to accomplish what I am trying to do. I have a Userform with four ComboBoxes and a ListBox. I also have a worksheet (Data) for data in the Userform to go to.
I want to select the information I want in the ComboBoxes, use a command button (Add) to have the ComboBox selections appear in the ListBox window - to in a way act as a preview before submitting. Then after "adding" up to 10 lines in the ListBox window - use a command button (Send ListBox Data to Worksheet) to send the ListBox Data to the Worksheet. This is a piece of an invoicing/quoting system I want to develop.
First Approach Considered:
Use the command button (Add) to transfer data to worksheet, then refresh the ListBox to show data in the worksheet range in the ListBox.
Second Approach Considered:
Add information first to ListBox then transfer ListBox data to worksheet range.
I am if my approach to what I am trying to accomplish is in the right direction and/or thoughts on how to proceed.
I have attached a Sample Worksheet to give an idea of what I am wanting to do. I am aware of how to input the ComboBox data to the worksheet. But not how to refresh the ListBox without closing the Userform. I have learned how to add selections to a ListBox. I have not been able to figure out how to add multiple ComboBox selections to the ListBox in contiguous horizontal columns, then repeat that in contiguous vertical rows.
I did my best to make sense! Any thoughts?
Bookmarks