I am looking for a way to use the value in a cell as a caption on a user form. Any help would be appreciated.
I am looking for a way to use the value in a cell as a caption on a user form. Any help would be appreciated.
Something like this?
Please Login or Register to view this content.
If posting code please use code tags, see here.
Thanks, but where would I put that code? and if I name that cell could I save some typing?
In the form's Initialize event perhaps.
You could name the cell if you wanted and it would save a few keystrokes.Please Login or Register to view this content.
Norie, Thanks for the help and this is what I have written.
addplayerf = form
asquare = name of the label in addplayerf form I am trying to get to change
sasquarename = named cell I am trying to reference
Please Login or Register to view this content.
Last edited by Chillywilly76; 02-05-2013 at 04:11 PM. Reason: correction
Don't change Userform_Initialize.
If 'sasquare' is a named range you need Range("sasquare"l.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks