ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Textboxes and ComboBoxes (https://www.excelbanter.com/excel-programming/354972-textboxes-comboboxes.html)

Jason Zischke

Textboxes and ComboBoxes
 
Hi All,

Is there a way to format textboxes and comboboxes to reconize that a number
has been typed into it so that I can say, If combo.value number Then ?

Thanks in advance

Jason

Jim F

Textboxes and ComboBoxes
 
If IsNumeric(ComboBox1.Value) = true then
if combo.value x then
end if
end if

"Jason Zischke" wrote:

Hi All,

Is there a way to format textboxes and comboboxes to reconize that a number
has been typed into it so that I can say, If combo.value number Then ?

Thanks in advance

Jason


Jason Zischke

Textboxes and ComboBoxes
 
Hi Jim F

That worked great, Thanks.

Jason

"Jim F" wrote:

If IsNumeric(ComboBox1.Value) = true then
if combo.value x then
end if
end if

"Jason Zischke" wrote:

Hi All,

Is there a way to format textboxes and comboboxes to reconize that a number
has been typed into it so that I can say, If combo.value number Then ?

Thanks in advance

Jason



All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com