Show ListBox based on CommandButton

[WimpieOosthuizen]

Good day

I have created a macro to create different list. On UserForm1 I have added command buttons.
I need the listBox to display the list as created in the tab's, e.g. Prepacks when I select CommandButton6 on UserForm1
This needs to display and then be able to close so another can be selected, e.g. Prosegur, etc
I have tried to use the following on my ListBox1 as the RowSource =OFFSET(Prepacks!$B$1:$D$100,0,0,COUNTAPrepacks!$B:$D),3)
It keeps giving me an error - "Could not set the RowSource property. Invalid property value"
If anyany can assit with creating one ListBox I am sure I will be able to create the others.

Any help will be greatly appreciated

[davesexcel]

If that is the formula you are using, there appears to be a bracket missing.

[Norie]

Not sure which listbox you want to populate but you could use this.

Please Login or Register  to view this content.

[WimpieOosthuizen]

Thank you Dave
Cant believe i didnt see it

[WimpieOosthuizen]

Also, Thank you Nori

[WimpieOosthuizen]

I have managed to conclude this
Thanks to everyone who assisted.
I have uploaded the completed file for completeness of this thread should anyone want to see or use it at a later stage