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.
Not sure what you mean.
Can you not say
if textboxSomething>0 then TextBoxSomthingelse=0 ?
Attempted that and it did not work. Need the correct verbage to have the data go into the right locations.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks