Hi all
I am sorry because I'm not familiar to VBA excel, so I have an Excel Workbook with several TextBox and ComboBox created in 02 pages on Userform

1. When the Userform appear all the Textbox will be clear.
2. when I select an item in the list of combobox1/page1/Userform
I will introduce more value corresponds to the element from Textbox1, Textbox2, TextBox3, 4 and 5

in my example:
When I select RD1 from ComboBox , I will enter data on all the TextBox (1,2,3,4 & 5)
then those TextBox values data will resend to my WorkSheet (Sheet1) by clicking on validate (CommandButton4) in "C19","C20","C21","C22" and "C23" respectively
as :
TextBox1.Value = Range("C19").Value
TextBox2.Value = Range("C20").Value
TextBox3.Value = Range("C21").Value
TextBox4.Value = Range("C22").Value
TextBox5.Value = Range("C23").Value
Whatever when Dropping down List in Combobox1 and selecting RD2, 3, 4 and 5 we will repeat the same operation for all those items of ComBoBox1
- RD2 selected in combox1 TextBox1,2,3,4 & 5 will filled by data then resend to D19,D20,D21,D22 & D23
- RD3 selected in combox1 TextBox1,2,3,4 & 5 will filled by data then resend to C19,C20,C21,C22 & C23
.
.
.
.
-RD5 selected in combox1 TextBox1,2,3,4 & 5 will filled by data then resend to G19,G20,G21,G22 & G23

Please see attached file link

and thank you for help ...


http://en.workupload.com/file/poqNKLyQ

Hi

The following links should give you the much needed insight on Forms Controls in Excel

http://office.microsoft.com/en-in/ex...010342745.aspx

http://support.microsoft.com/kb/291073

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)