activate cancel button in a inputbox

**mania112** · 10-19-2009, 05:52 AM

in vb, i have the following code to enter clients details, which works fine:

Please Login or Register  to view this content.

We have some new staff starting next week, so i wanted to tidy a few things up, namely when you 'add new client' the inputbox appears, but at the moment if you hit cancel the code chokes and the usual vb runtime error appears.

all i wanted therefore is an idea of how to apply a line or two to allow the user to cleanly cancel and return to the 'client list' sheet.

i'm sure this is quite simple, i just hope it doesnt need a complete overhaul of the way this code's written.

many thanks

**Richard Buttrey** · 10-19-2009, 06:20 AM

Hi,

Please Login or Register  to view this content.

Incidentally provided the user always enters dates in the ddmmyy format you will be OK, but you might want to consider what would happen if a US user say entered mmddyy. You might like to consider capturing the day, date and month in separate listboxes which contain days 1-31, months January - December and Year numbers. Then you can build the Date variable by using the DateSerial() instruction.

HTH

**mania112** · 10-19-2009, 07:08 AM

thanks, that worked great.

I have another problem while doing this 'tidy up'

i'll have to start a new thread on it, for some reason i cannot get to the manage attachments pane, hoping a new thread will solve the problem

**royUK** · 10-19-2009, 07:09 AM

Originally Posted by mania112

thanks, that worked great.

I have another problem while doing this 'tidy up'

i'll have to start a new thread on it, for some reason i cannot get to the manage attachments pane, hoping a new thread will solve the problem

You should start a new Thread for additional questions, add a link to this one if i might help.