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: 71
Default Qn: Display Text in TextBox in Userform

Hello Everyone,

I created a Userform with about 15 different Textboxes to input data. I
also have a checkbox option that allows the user to select if some of the
data will be repeated (ie: Place Check Mark here if numbers are the same).
Now, in my formulas, it works just fine. It will save the data from the
first 5 textboxes to the appropriate cells, and repeats the data to the new
cells like I want. Now, what I am looking for it to do is: When I enter my
numbers into the first 5 texboxes of the userform1, (and the data is to be
repeated); I place a check mark in the checkbox1, I would like the same data
DISPLAYED in the textboxes of the userform. I would like to see those
numbers in the userform itself. As it stands now, I place a checkmark and
the textboxes remain empty. But, it will write correctly to the appropriate
cells like I want it to. I would just like to see the data in the userform
before I hit "OK". Can somebody help me out with the VBA code on that??
Thanks in advance..mv


 
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 textbox Phil Excel Worksheet Functions 5 January 16th 05 06:59 PM
Textbox in userform shaharul[_6_] Excel Programming 3 April 15th 04 12:54 PM
formatting text in TextBox in UserForm Kevin Excel Programming 2 November 7th 03 01:34 PM
UserForm - display text message then run code Robert[_13_] Excel Programming 3 September 13th 03 11:37 AM
UserForm TextBox to ActiveSheet TextBox over 256 characters Dan E[_2_] Excel Programming 1 July 28th 03 07:36 PM


All times are GMT +1. The time now is 07:10 AM.

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"