ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   initialize value in userform when opened (https://www.excelbanter.com/excel-programming/378818-initialize-value-userform-when-opened.html)

strive4peace

initialize value in userform when opened
 
Hi All,

I have a userform (name=imagetype), that has an unbound texbox control
(name=MaxNulls). When the userform opens, I would like to initialize
the value of MaxNulls to 3 ...is this possible?

thanks!


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access

*

Dave Peterson

initialize value in userform when opened
 
Behind the userform:

Private Sub UserForm_Initialize()
me.maxnulls.value = "3"
End Sub




strive4peace wrote:

Hi All,

I have a userform (name=imagetype), that has an unbound texbox control
(name=MaxNulls). When the userform opens, I would like to initialize
the value of MaxNulls to 3 ...is this possible?

thanks!

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access

*


--

Dave Peterson

strive4peace

initialize value in userform when opened
 
fantastic! thanks, Dave!


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access

*



Dave Peterson wrote:
Behind the userform:

Private Sub UserForm_Initialize()
me.maxnulls.value = "3"
End Sub




strive4peace wrote:
Hi All,

I have a userform (name=imagetype), that has an unbound texbox control
(name=MaxNulls). When the userform opens, I would like to initialize
the value of MaxNulls to 3 ...is this possible?

thanks!

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access

*




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

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