Can anyone help?????????????????

amarj

New Member
Joined
Aug 31, 2006
Messages
13
Hi There.

Is it possible for VB to retrieve data from excel; range a1:a34 in sheet 1 of active book and display this information in a text box / image on useform?

Thanks


Extreme Novice!!!!!!!!!!!
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,028
Why not start with a book that introduces VBA program in an organized manner? Jumping into userforms is not necessarily the best way for an "extreme novice" to use/learn VBA.
 

amarj

New Member
Joined
Aug 31, 2006
Messages
13
can anyone else help me?

im reading vba macro - but dont have the time as this is part of a task requested and overdue for work.

help - is this feasible?
 

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
Hi

Rather than a text box, try a list box. Have it linked to the source range.


Tony
 

amarj

New Member
Joined
Aug 31, 2006
Messages
13
Thanks Tony - It is feasible then.

How do you link the source range to the text box?

is this a simple code?
 

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
Hi

IF you are going to have a consistent source then you can set the rowsource property in the listbox to refer to the range on the sheet.


Tony
 

Watch MrExcel Video

Forum statistics

Threads
1,114,407
Messages
5,547,766
Members
410,811
Latest member
adustin42
Top