+ Reply to Thread
Results 1 to 3 of 3

User form in excel- need help in writing code with if/then statement

  1. #1
    Registered User
    Join Date
    04-03-2013
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    78

    Post User form in excel- need help in writing code with if/then statement

    frm Inventory - I need to write code when the numeric data entered into txtIssued is >0 then txtReceived be <1 and vice versa. This data needs to be stored into Sheet1. The txtIssued is in column C and the txtReceived is in column D.




    Please Login or Register  to view this content.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,002

    Re: User form in excel- need help in writing code with if/then statement

    Not sure what you mean.
    Can you not say
    if textboxSomething>0 then TextBoxSomthingelse=0 ?

  3. #3
    Registered User
    Join Date
    04-03-2013
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    78

    Re: User form in excel- need help in writing code with if/then statement

    Attempted that and it did not work. Need the correct verbage to have the data go into the right locations.

+ 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