How to make textbox value negative at runtime?

**ImranBhatti** · 12-01-2016, 08:08 AM

Hello Excel Experts!

My question is " Is it possible to make positive number of a textbox as negative when it reached to worksheet?"

I am using this trick but it pops up " type mismatch error"

Please Login or Register  to view this content.

Any suggestions would be appreciated.

Best Regards
Imran Bhatti

**Kenneth Hobson** · 12-01-2016, 08:21 AM

Use Val(). e.g.

Please Login or Register  to view this content.

**kasan** · 12-01-2016, 08:21 AM

try this way

Please Login or Register  to view this content.

**ImranBhatti** · 12-01-2016, 08:27 AM

Like always sir Keneth.

Thanks

**ImranBhatti** · 12-01-2016, 08:34 AM

kasan your code produced type mismatch . Anyway thanks for reviewing my problem.

How to make textbox value negative at runtime?

LinkBack

Thread Tools

Rate This Thread

Display

How to make textbox value negative at runtime?

Re: How to make textbox value negative at runtime?

Re: How to make textbox value negative at runtime?

Re: How to make textbox value negative at runtime?

Re: How to make textbox value negative at runtime?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Userform VBA, textbox in a frame - runtime error 438

[SOLVED] Make certain Textbox negative value based on CheckBox

help to convert textbox value to negative based on another textbox value

How to make one TextBox value equal another TextBox value?

Multiple TextBox Input From Runtime Records On Userform

Formula to make product of two negative numbers negative

Insert a Textbox in a Frame during runtime

Bookmarks

Bookmarks

Posting Permissions