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.
Hi Joe,
Welcome to VBAX
[VBA]Label1.Caption = Range("A1")[/VBA]
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
dam that really is simple.... thanks
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"
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
Posting Permissions
Reply With Quote
