+ Reply to Thread
Results 1 to 7 of 7

multiple text boxes on userform

  1. #1
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    222

    multiple text boxes on userform

    Hi Guys

    Been busy learning VBA

    have now created a user form that now needs to check the drop down

    Penny, charlotte etc then looks up what date the calander says and then enters the numeric value next the the name and in the Month.

    not sure at the moment if the date range needs to be the same on sheet3 or can iy continually add to the months.

    hope it makes sense

    cheers

    Ps Userform ctlr + m
    Attached Files Attached Files

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: multiple text boxes on userform

    Hello stephen1000,

    Here is the updated code for your "Add" button.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    222

    Re: multiple text boxes on userform

    Hi Leith

    thanks for that

    But Wks.Cells(Rng.Rows(R).Row, C) = txtData

    Run time error 1004

    any ideas

    Thanks

    stephen

  4. #4
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    222

    Re: multiple text boxes on userform

    Quote Originally Posted by stephen1000 View Post
    Hi Leith

    thanks for that

    But Wks.Cells(Rng.Rows(R).Row, C) = txtData

    Run time error 1004

    any ideas

    Thanks

    stephen

    Hi Leith,

    problems seems to be when month is pre March 09

  5. #5
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: multiple text boxes on userform

    Hello stephen1000,

    I added error checking to macro and fixed the date problem. This should work fine...
    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    222

    Re: multiple text boxes on userform

    Quote Originally Posted by Leith Ross View Post
    Hello stephen1000,

    I added error checking to macro and fixed the date problem. This should work fine...
    Please Login or Register  to view this content.
    Thank you again for that

    will look at it today

    Cheers

  7. #7
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Norfolk UK
    MS-Off Ver
    2007
    Posts
    222

    Re: multiple text boxes on userform

    Hi Leith

    The data that goes in to cells when add is pressed need to be in number format.

    Sorry if its my fault.

    stephen

+ 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