LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 542
Default How to set value of Textbox in loop

Im trying to give a textbox in a userform an initial value. Its not straight
forward because the name of the textbox is not always the same (dynamic
userform). I've setup this loop but cant get oCont.Value to work. Does anyone
know why? Any Help is much appreciated. Thanks in advance

Dim oPage As Page, oCont As control

For Each oPage In DataPlate.MultiPage1.Pages
If oPage.Index = 3 Then Exit For
For Each oCont In oPage.Controls
If TypeName(oCont) = "TextBox" Then
If InStr(1, oCont.Tag, "PD") 0 Then
'SOMEHOW SET THE VALUE OF THE TEXTBOX HERE
ElseIf InStr(1, oCont.Tag, "Proj") 0 Then
'SOMEHOW SET THE VALUE OF THE TEXTBOX HERE
End If
End If
Next oCont
Next oPage
 
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
Collecting textbox input within a for loop [email protected] Excel Programming 1 May 19th 06 08:01 PM
Loop Through textbox in Excel sweet Excel Programming 1 January 24th 06 04:04 PM
loop through textbox in Excel [email protected] Excel Programming 2 January 24th 06 04:01 PM
Using a DO loop to add values into a textbox Ian B Excel Programming 2 September 12th 05 07:07 PM
loop in a textbox libby Excel Programming 1 August 3rd 04 11:30 PM


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

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

About Us

"It's about Microsoft Excel"