Hello,
I'm one of the "new ones" again with a lot of questions!!
Ok here we go!
I would like to be able to open a UserForm just by clicking (or double clicking) on a cell... Is there any action that enables this?
Thank you for answering?
eph!e
Hello,
I'm one of the "new ones" again with a lot of questions!!
Ok here we go!
I would like to be able to open a UserForm just by clicking (or double clicking) on a cell... Is there any action that enables this?
Thank you for answering?
eph!e
See the attached file.
To do it, open excel, open VB editor (alt + f11), double click (in project window) on the sheet where you want to select cell
in the left combo (where is displayed general) choose worksheet and in the right combo choose selection change
here use the code:
if target.address (false,false) = "B2" (the letter must be upper case)userform1.showend if
Regards.
Antonio
Thank you Antonio,
It works !! Cool
ephie
I'm sorry but I missed the attachment.
i'm happy to knoew you resolved.
Regards.
Antonio
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks