Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Shroter Way Text boxes

  1. #11
    Board Regular
    Join Date
    Mar 2002
    Location
    Arkansas
    Posts
    358
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thx Oz,Your method sounds realy simple,but a beginer here, I think Im a little bit lost on that consept. But thanks for your time. Dan

  2. #12
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi dantb

    It is really very easy. While in the VBE right click on the TextBox and select Properties. Then scroll down to "ControlSource" and in here place A1 or whatever cell you wish to link to.

    It is basically the same for the Tag Property, ie just type A1 Then use the loop I showed to enter all TextBox entries to the desired cells.




  3. #13
    Board Regular
    Join Date
    Mar 2002
    Location
    Arkansas
    Posts
    358
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ok thx Oz, will try and thanks again, Have a good evening !

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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