On my Userform1 i have MULTIPAGES with
2 Labels
3 Command Buttons
On Each Pages
When i Double click on Cell "W8"
then Data Came from Cell " R8" to Label1 and Date from Cell "R9" to Label2
When i Press On Command Buttons 1 the Value in Cell "W8" change to "1"
and if i Press On Command Buttons 2 the Value in Cell "W8" change to "2"
And Press on Command Buttons 3 The userform CLose.
and i can see the Change in Cell "W8"
That Part WORKS ok
But I want To use the Userform WITHOUT the Multipage Beacause my File I getting Big and in the File ill Getting 14 Userforms All With Multipage's
so i need a Function to Use the same Userform to do exactly the same Thing but on Others Cells
The userform apear When i Doubleclick on Specific Cell's then Value from those Specific Cell's Apear on Labels and The Command Function's Work for those Specific Cell's
On one sheets Ill Have 9 Cells where to Doubleclick to Read Values
Doubleclick Sequence No matter Wich On i Doubleclick W8 or W12 or W16 or W20 or AD10 or Ad20 the Same Userform Apear and Could Read the Value from Wich Cell ill Doubleclick on
1. Doubleclick on Cell "W8" Data from Cell "R8" to Label1 and Data from Cell "R9" to Label2 and value from Command Buttons 1 or 2 to Cell "W8"
2. Doubleclick on Cell "W12" Data from Cell "R12" to Label1 and Data from Cell "R13" to Label2 and value from Command Buttons 1 or 2 to Cell "W12"
3. Doubleclick on Cell "W16" Data from Cell "R16" to Label1 and Data from Cell "R17" to Label2 and value from Command Buttons 1 or 2 to Cell "W16"
4. Doubleclick on Cell "W20" Data from Cell "R20" to Label1 and Data from Cell "R21" to Label2 and value from Command Buttons 1 or 2 to Cell "W20"
5. Doubleclick on Cell "AD10" Data from Cell "AD10" to Label1 and Data from Cell "AD11" to Label2 and value from Command Buttons 1 or 2 to Cell "AD10"
6. Doubleclick on Cell "AD20" Data from Cell "AD20" to Label1 and Data from Cell "AD21" to Label2 and value from Command Buttons 1 or 2 to Cell "AD20"
Hope this was Enough Info
2 Labels
3 Command Buttons
On Each Pages
When i Double click on Cell "W8"
then Data Came from Cell " R8" to Label1 and Date from Cell "R9" to Label2
When i Press On Command Buttons 1 the Value in Cell "W8" change to "1"
and if i Press On Command Buttons 2 the Value in Cell "W8" change to "2"
And Press on Command Buttons 3 The userform CLose.
and i can see the Change in Cell "W8"
That Part WORKS ok
But I want To use the Userform WITHOUT the Multipage Beacause my File I getting Big and in the File ill Getting 14 Userforms All With Multipage's
so i need a Function to Use the same Userform to do exactly the same Thing but on Others Cells
The userform apear When i Doubleclick on Specific Cell's then Value from those Specific Cell's Apear on Labels and The Command Function's Work for those Specific Cell's
On one sheets Ill Have 9 Cells where to Doubleclick to Read Values
Doubleclick Sequence No matter Wich On i Doubleclick W8 or W12 or W16 or W20 or AD10 or Ad20 the Same Userform Apear and Could Read the Value from Wich Cell ill Doubleclick on
1. Doubleclick on Cell "W8" Data from Cell "R8" to Label1 and Data from Cell "R9" to Label2 and value from Command Buttons 1 or 2 to Cell "W8"
2. Doubleclick on Cell "W12" Data from Cell "R12" to Label1 and Data from Cell "R13" to Label2 and value from Command Buttons 1 or 2 to Cell "W12"
3. Doubleclick on Cell "W16" Data from Cell "R16" to Label1 and Data from Cell "R17" to Label2 and value from Command Buttons 1 or 2 to Cell "W16"
4. Doubleclick on Cell "W20" Data from Cell "R20" to Label1 and Data from Cell "R21" to Label2 and value from Command Buttons 1 or 2 to Cell "W20"
5. Doubleclick on Cell "AD10" Data from Cell "AD10" to Label1 and Data from Cell "AD11" to Label2 and value from Command Buttons 1 or 2 to Cell "AD10"
6. Doubleclick on Cell "AD20" Data from Cell "AD20" to Label1 and Data from Cell "AD21" to Label2 and value from Command Buttons 1 or 2 to Cell "AD20"
Hope this was Enough Info