ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Object required error 424 why getting? (https://www.excelbanter.com/excel-programming/386988-object-required-error-424-why-getting.html)

Chet

Object required error 424 why getting?
 
Anyone know why I might be getting an error message saying "Object
required error 424" on some code like this: I am trying to put this
initial value into a text box. (34948)

FAMIS092Form.TextBox1.Value = "34948"

Thanks,
Chet


Bob Flanagan

Object required error 424 why getting?
 
Chet, confirm that your form is named FAMIS092Form and that it has a textbox
named TextBox1. I just created such and your code worked fine.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel


Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Chet" wrote in message
ups.com...
Anyone know why I might be getting an error message saying "Object
required error 424" on some code like this: I am trying to put this
initial value into a text box. (34948)

FAMIS092Form.TextBox1.Value = "34948"

Thanks,
Chet




Chet

Object required error 424 why getting?
 
Thank you .. I had mis-named the form.. !.... Chet

Bob Flanagan wrote:
Chet, confirm that your form is named FAMIS092Form and that it has a textbox
named TextBox1. I just created such and your code worked fine.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel


Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Chet" wrote in message
ups.com...
Anyone know why I might be getting an error message saying "Object
required error 424" on some code like this: I am trying to put this
initial value into a text box. (34948)

FAMIS092Form.TextBox1.Value = "34948"

Thanks,
Chet




All times are GMT +1. The time now is 12:31 AM.

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