Blank CInt & Cdec textbox values with mismatch

**johnny_p** · 02-04-2015, 05:18 AM

Hi all

I'm having trouble with this If statement as i'm getting "Typemismatch 13" on Textboxes with blank values.

I have to check all of the Textboxes at once for this to work. Textboxes 1-3 will have whole numeric values "10,000" and Textboxes 4-6 are either decimals or whole numbers "24" or "24.4".

When one of the textboxes are blank I debug with a typemismatch. Any ideas?

Thanks

Please Login or Register  to view this content.

**romperstomper** · 02-04-2015, 05:23 AM

Prefix them with "0":

Please Login or Register  to view this content.

and so on.

**johnny_p** · 02-04-2015, 05:39 AM

Thanks, that has sorted the Debug. What did the "0" trick do?

**romperstomper** · 02-04-2015, 06:30 AM

If you have a blank textbox, it gives you just "0" which will work with the coercion functions. If you have an existing value, putting "0" on the start obviously doesn't affect the value.

**johnny_p** · 02-04-2015, 07:00 AM

Thanks

Neat trick

Blank CInt & Cdec textbox values with mismatch

LinkBack

Thread Tools

Rate This Thread

Display

Blank CInt & Cdec textbox values with mismatch

Re: Blank CInt & Cdec textbox values with mismatch

Re: Blank CInt & Cdec textbox values with mismatch

Re: Blank CInt & Cdec textbox values with mismatch

Re: Blank CInt & Cdec textbox values with mismatch

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Type mismatch on a date textbox when leaving it blank

Type Mismatch-calculating textbox values from different multipage tabs

Convert text to number cDec(xCell.Value)

Mismatch in VBA on TextBox

CInt() conversion & inputbox

Bookmarks

Bookmarks

Posting Permissions