| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code bug
If txtPAI.Value 100 Then MsgBox "Percentage cannot exceed 100%", 64, "Error Message" CloseButton.Locked = True CloseButton.BackColor = &H80000013 txtPAI.BackColor = &H80000013 txtPAI.SetFocus Else If txtPAI <= 100 Then CloseButton.Locked = False CloseButton.BackColor = &H80000010 txtPAI.BackColor = &H80000005 End If Works ok until textbox is left blank "" which returns the erro message. What am I missing here? Cheers Peter (new to VBA -- peter.thompso ----------------------------------------------------------------------- peter.thompson's Profile: http://www.excelforum.com/member.php...fo&userid=2968 View this thread: http://www.excelforum.com/showthread.php?threadid=49628 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code bug
Maybe...
If Val(txtPAI.Value) 100 Then It might be a good idea to add a check: if isnumeric(txtPAI.value) = false then 'some warning message... .... "peter.thompson" wrote: If txtPAI.Value 100 Then MsgBox "Percentage cannot exceed 100%", 64, "Error Message" CloseButton.Locked = True CloseButton.BackColor = &H80000013 txtPAI.BackColor = &H80000013 txtPAI.SetFocus Else If txtPAI <= 100 Then CloseButton.Locked = False CloseButton.BackColor = &H80000010 txtPAI.BackColor = &H80000005 End If Works ok until textbox is left blank "" which returns the error message. What am I missing here? Cheers Peter (new to VBA) -- peter.thompson ------------------------------------------------------------------------ peter.thompson's Profile: http://www.excelforum.com/member.php...o&userid=29686 View this thread: http://www.excelforum.com/showthread...hreadid=496280 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code bug
Thanks Dave, problem fixed! Cheers Peter -- peter.thompson ------------------------------------------------------------------------ peter.thompson's Profile: http://www.excelforum.com/member.php...o&userid=29686 View this thread: http://www.excelforum.com/showthread...hreadid=496280 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
| Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
| run code on opening workbook and apply code to certain sheets | Excel Programming | |||
| stubborn Excel crash when editing code with code, one solution | Excel Programming | |||
| option buttons run Click code when value is changed via VBA code | Excel Programming | |||
![peter.thompson[_18_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
