PDA

View Full Version : Solved: how to display a cell value in a userform



ThePigeon
02-05-2009, 03:31 PM
hey.

(I’m using vba in excel 2007)

I know its really simple question and should be able to work it out for myself, but I’ve stuck on it for so long I had to ask…

What I want to do is take the value from a cell and display in an ActiveX control in a user form. I’ve made the userfrom and a “label” ActiveX control in the form. Now I want to take the value from cell A1 and put it into the label… if any one could help us out with doing that… that would be great.

Thanks very much,

Joe.

mdmackillop
02-05-2009, 03:33 PM
Hi Joe,
Welcome to VBAX

Label1.Caption = Range("A1")

ThePigeon
02-05-2009, 03:35 PM
dam that really is simple.... thanks :D

Simon Lloyd
02-05-2009, 06:30 PM
ThePigeon, If your query has been solved please take a moment to let us and eveyone else know by going to, Thread Tools > "Mark This Thread As Solved"