LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default UserForm Initialization

On Feb 21, 1:15 pm, "Patrick C. Simonds"
wrote:
Sorry if this is a second post, but my reader said my original message was
no longer on the server.

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


Hrm, I couldn't see my reply to the original post so I am trying
again....

Private Sub UserForm_Initialize()

Me.TextBox1.Value =
ThisWorkbook.Sheets("Sheet1").Range("A4").Value
' Or
' Me.TextBox1.Value = ThisWorkbook.ActiveSheet.Range("A4").Value

End Sub
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
UserForm Initialization Patrick C. Simonds Excel Programming 2 February 21st 08 09:01 PM
userform initialization problem Ken Excel Programming 2 August 23rd 06 08:19 PM
UserForm Initialization Patrick Simonds Excel Programming 1 January 21st 05 02:40 AM
Userform Initialization Patrick Simonds Excel Programming 2 May 22nd 04 10:17 PM
List box initialization Daniel Thompson Excel Programming 0 July 15th 03 05:17 PM


All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"