ExcelBanter - UserForm Initialization

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - UserForm Initialization (https://www.excelbanter.com/excel-programming/406464-userform-initialization.html)

Patrick C. Simonds

UserForm Initialization

In UserForm Initialization, is there any way to have TextBox4 always show
the value of cell A4?

JLGWhiz

UserForm Initialization

UserForm1.TextBox4.Text = Sheets(1).Range("A4").Value

Change the UserForm name and Sheet as required.

"Patrick C. Simonds" wrote:

In UserForm Initialization, is there any way to have TextBox4 always show
the value of cell A4?

JLGWhiz

UserForm Initialization

Actually, in the Initialize event you don't even need to refer to the UserForm.

"Patrick C. Simonds" wrote:

In UserForm Initialization, is there any way to have TextBox4 always show
the value of cell A4?

All times are GMT +1. The time now is 06:16 AM.