A
Arjan
Hi all,
I would like to ask your help for my challange![Smile :) :)](/styles/default/custom/smilies/smile.gif)
Scope:
I have 15 sheets, on every sheet there are 3 colunms (A, B and C) filled
with data..(the number of rows do differ)
Question:
On a 'Userform' I have made 15 commandbuttons and 1 'Listbox' without input
field..
This is what I would like to do:
When CommandButton1 is clicked, I want the data (from page 1) to be shown in
the Listbox..
etc. so..
When commandbutton2 is clicked, I want the data (from page 2) to be shown in
the Listbox..
When commandbutton3 is clicked, I want the data (from page 3) to be shown in
the Listbox..
...
When CommandButton15 is clicked, I want the data (from page 15) to be shown
in the Listbox..
How can I do this with VBA? are there expamples? So I can see how I can do
it?
thnx! for your help..
Arjan
the Netherlands
I would like to ask your help for my challange
![Smile :) :)](/styles/default/custom/smilies/smile.gif)
Scope:
I have 15 sheets, on every sheet there are 3 colunms (A, B and C) filled
with data..(the number of rows do differ)
Question:
On a 'Userform' I have made 15 commandbuttons and 1 'Listbox' without input
field..
This is what I would like to do:
When CommandButton1 is clicked, I want the data (from page 1) to be shown in
the Listbox..
etc. so..
When commandbutton2 is clicked, I want the data (from page 2) to be shown in
the Listbox..
When commandbutton3 is clicked, I want the data (from page 3) to be shown in
the Listbox..
...
When CommandButton15 is clicked, I want the data (from page 15) to be shown
in the Listbox..
How can I do this with VBA? are there expamples? So I can see how I can do
it?
thnx! for your help..
Arjan
the Netherlands