ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MaxLength Property issues (https://www.excelbanter.com/excel-programming/342471-maxlength-property-issues.html)

JNW

MaxLength Property issues
 
I have a textbox on a userform that needs to allow different lengths of text
based on a radial selection. In the Optionbutton1_change event I tried
putting:

If optionbutton1.value = true then
textbox1.maxlength = 7
elseif optionbutton2.value = true then
textbox1.maxlength = 9
end if

But, when I try to execute it gives a compile error saying that the method
or data member can't be found.

Any ideas?

JNW

MaxLength Property issues
 
Sorry, I've been trying to change the maxlength of a label.

*ahhh!!!*

"JNW" wrote:

I have a textbox on a userform that needs to allow different lengths of text
based on a radial selection. In the Optionbutton1_change event I tried
putting:

If optionbutton1.value = true then
textbox1.maxlength = 7
elseif optionbutton2.value = true then
textbox1.maxlength = 9
end if

But, when I try to execute it gives a compile error saying that the method
or data member can't be found.

Any ideas?



All times are GMT +1. The time now is 02:23 AM.

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