This should be simple but... I am having problems....

  • Thread starter Thread starter Newbie1
  • Start date Start date
N

Newbie1

When I push a button to go to the next record, IF TextBox76 is NOT empty and
has CHANGED,
I would like to stuff the date/time into TextBox75 and then combine
Textbox75, TextBox76, TextBox72 and TextBox77
These would then be added to TextBox74 (a log) and I would LIKE to have each
dta from the prev textboxes seperated with " | "

TextBox76 and TextBox77 are date/time
Most of this I can figure out, but I am not sure on how to test for EMPTY or
CHANGED (will I need a public varible?)

Thanks
 
Using public variables, declared in a regular module, will work. to store
the values when the form is first displayed. To test if a textbox is empty,
test to see if the Text property is equal to "".

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please tell me how to make this more efficient and repeatable 3
Save a date as a variable and run/convert formula against the vari 2
This should be simple? 1
Not sure this should be Excel or ACCESS 16
Excel Need Countifs Formula Help 0
Comparing Dates 2
This should be simple but... 3
Userform, Calender, Problems with Todays Date 4

Back
Top