View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arjan[_2_] Arjan[_2_] is offline
external usenet poster
 
Posts: 1
Default Userform - with Commandbutton fill a Listbox with data..

Hi all,

I would like to ask your help for my challange :)

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