Userform data entry by clicking on a cell instead of typing

[olivierpbeland]

Seems like a simple problem but I couldn't find anything on the interwebs.

I have a textbox which is currently filled by typing the name of an item (e.g. Project xyz).

Is there a way to also allow users to click on a cell in the sheet (i.e. containing text value "project xyz") rather than typing it in?

Thanks.

[Charles]

Hi,

I think you can probably use a "BeforeDoubleClick" event to send the data to the textbox.

[olivierpbeland]

Thank you but I am not sure how to use this in practice. Can you please give a short code example?
Thanks.

[Charles]

Hi,

This is a sample.

Copy to the worksheet code module.
When you doubleclick the data it should populate the Activex textbox.
You will see the change as soon as you tab off the cell you double clicked on.

Please Login or Register  to view this content.

[olivierpbeland]

Sorry, still not getting it. Would you mind adding to the code in the attached WS?
The box to fill by clicking is "Name of the Project".

Many thanks.

[Charles]

Hi,

I'll take a look...

[Charles]

Hi,

I changed the Properties of the form to "Modal" to False.
This allows you to "Double Click" the Item you wish to see in the userform.
Sorry to say when I first looked at this I thought it was for worksheet textbox.