+ Reply to Thread
Results 1 to 5 of 5

controlsource property for userform

  1. #1
    Forum Contributor
    Join Date
    03-02-2010
    Location
    Denver, CO
    MS-Off Ver
    Excel 2010
    Posts
    109

    controlsource property for userform

    This is probably a stupidly simple question. I have a userform. The information entered into it will always go into the same cell. I'm guessing that the easiest way to set that up would be to set the controlsource to that cell. But I'm not sure what I enter to make that work. I want to link it to (sheet name) friday actual, cell a3.

    Thanks for the help.
    Last edited by just_some_guy; 03-09-2010 at 11:26 AM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: controlsource property for userform

    The control source property can be set in the Properties window. Setting this property means that any changes to control will be made to the cell,but also any changes to the cell will show in the control
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor
    Join Date
    03-02-2010
    Location
    Denver, CO
    MS-Off Ver
    Excel 2010
    Posts
    109

    Re: controlsource property for userform

    royUK,

    but what would I enter into that cell? I've never dealt with control source before, and I'm not what I'm actually supposed to type in there.

    Thanks,

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: controlsource property for userform

    You would enter:
    'Friday actual'!A3
    Remember what the dormouse said
    Feed your head

  5. #5
    Forum Contributor
    Join Date
    03-02-2010
    Location
    Denver, CO
    MS-Off Ver
    Excel 2010
    Posts
    109

    Re: controlsource property for userform

    Perfect! Thanks RomperStomper and royUK. I was searching through google last night, and every site talked about it, but not what to actually enter into the cell. You are both fantastic!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1