VBA code gives wrong result

**aman1234** · 02-29-2012, 05:31 AM

Hi guys

The following code doesn't give me the right result. If I type the following values in comboboxes:

combobox3=6
combobox4=4
combobox5=2012

Then the following code displays "Normal" but it should be "Post Dated".

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Can anyone please help me out in this.

Thanks

**Andrew-R** · 02-29-2012, 05:46 AM

My first guess is that it's treating TextBox1.Value as a string rather than as a date, so assigning it a value of 0 for the numeric comparison.

**aman1234** · 02-29-2012, 05:52 AM

Thanks Andrew-R, so what changes do I need to make to get it working.

**aman1234** · 02-29-2012, 05:54 AM

Thanks OnErrorGoTo0 , It works perfetcly fine ow.

**Andrew-R** · 02-29-2012, 06:01 AM

Originally Posted by OnErrorGoto0

I think you're right about the cause but all strings are treated as greater than any number, hence the result.

Once again I learn something new on here. Thanks OnError.

**Richard Buttrey** · 02-29-2012, 06:13 AM

... and further to the answers you've been given your message box was always going to show 'Normal' since you'd applied a literal to it rather than the status variable.

Regards

**OnErrorGoto0** · 02-29-2012, 06:21 AM

Oh yeah!

**royUK** · 02-29-2012, 06:57 AM

There's an example of comboboxes being used for dates here

VBA code gives wrong result

LinkBack

Thread Tools

Rate This Thread

Display

VBA code gives wrong result

Re: VBA code gives wrong result

Re: VBA code gives wrong result

Re: VBA code gives wrong result

Re: VBA code gives wrong result

Re: VBA code gives wrong result

Re: VBA code gives wrong result

Re: VBA code gives wrong result

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions