With Selection Input Cell Value or Range into User Form

**bdb1974** · 03-02-2010, 01:36 PM

Hi all,

I'm trying to setup some code that, if a user selects a specific cell then that cell value will
be inputed into a user form. I tried reversing some code that I have that adds a users
cell range selection to cell, but something is still not right.

Here's what I have thus far:

Please Login or Register  to view this content.

Any help is appreciated.
Thanks,

BDB

**bdb1974** · 03-02-2010, 04:02 PM

...Just an added explanation. Currently when I click in a cell, will add the
Cell Address ,

For instance, clicking on C17, puts "$C$17" into my userform.

I need the cells value added to the userform.

So if the value in C17 = "MYNAME" then "MYNAME" will be put into the userform.

HTH's.

BDB

**bdb1974** · 03-02-2010, 06:39 PM

Hi all, I found the following at http://http://www.erlandsendata.no/e...tboxfillunique

Please Login or Register  to view this content.

I was hoping that I could incorporate this into my userform using refedit,
I'm put together this:

Please Login or Register  to view this content.

Using it with the Function Code, I'm get the same result. Bascially back to square 1.
... I wouldn't think it should be so difficult getting the the cell value place into a userform box by selecting a cell manually or with code.

Again any input is greatly appreciated.

BDB

**bdb1974** · 03-03-2010, 01:15 PM

If possible,

Can someone provide any type of an example of adding a cell value into a userform by "clicking" & making a cell active or making an cell active/select through code?

Thanks,

BDB

**bdb1974** · 03-04-2010, 05:36 PM

Alrighty guys and gals,

I have finally put together some code that's working for me.
In case your interested, I've atached an example booklet w/code.

I think this is pretty cool. Hopefully you will too.

Regards,

BDB