Userform Help

[Hjemmet]

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

 

[MikeVol]

Hello! Could you please upload a sample workbook (without sensitive data) to a file-sharing site like Dropbox.com or Google Drive, and then share the link here? Also, ensure that the link is accessible to anyone. Thanks.

 

[Hjemmet]

Hello! Could you please upload a sample workbook (without sensitive data) to a file-sharing site like Dropbox.com or Google Drive, and then share the link here? Also, ensure that the link is accessible to anyone. Thanks.

I upload sample when i get home From job Later

 

[Hjemmet]

I have made a Short version So it Not Is so Big

NEW Version Dart Cup (Change to English).xlsm

Shared with Dropbox

www.dropbox.com

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Help to userform

I need Som Help with VBA code for My Userform.. on Userform i have 2 Label 3 Buttons. When Double Click On Cell H6 And Read value from Cell D4 and D10 to Labels on userform (No problem with that And Close Userform Button Label 1 Read Value from Cell D4 Label 2 Read Value from Cell D10...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem, but as this is not the first time you have done so without links, please note that future breaches of this rule may result in a loss of posting privileges.

 

[Hjemmet]

Arhhhh My Mistake sorry