Excel 2007 : initializing user form

**dmartinez** · 07-20-2010, 11:05 AM

hello,

I´m having trouble initializing my userform with some values. it was working a couple of days back but for some reason not working now..

this is the code im using to do this.

Private Sub UserForm1_Initialize()
Dim iRow As Long
Dim ws As Worksheet

TextBox12.Value = Now()
TextBox13.Value = Range("a50")


End Sub

**Andy Pope** · 07-20-2010, 11:28 AM

The event name does not usually contain the userform name.
So that routine is just a private subroutine within the userform code module that is not being executed.

Private Sub UserForm_Initialize()
Dim iRow As Long
Dim ws As Worksheet

TextBox12.Value = Now()
TextBox13.Value = Range("a50")


End Sub

In design mode double click the userform. Does the code editior open in this routine?

**dmartinez** · 07-20-2010, 11:58 AM

thanks a lot problem solved..

Excel 2007 : initializing user form

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

initializing user form

Re: initializing user form

Re: initializing user form

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions