MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Setting Property's to nothing or null


Posted by Daniel James on February 12, 2002 10:58 PM

I'm using forms for data entry, and want to clear each textbox once data has been submitted so old data isn't sitting there next time someone enters data... but i can't get it to clear... i've tried setting each property to null, but it cracks it...

Sample of my code:

Sub ClearData()

With Me
.OperatorBox.Text = Null
.DateBox.Text = Null

etc...

i know i can't use null like this... but i don't know how i should... any help would be ace!

Cheers


Posted by Ivan F Moala on February 12, 2002 11:21 PM

.DateBox.Text = "" (NT)