Need to pass the active cell to a String Variable

**Darth269** · 02-17-2014, 04:15 PM

I'm trying to select a cell, click a button (command button, P1 - Running in "Private Sub P1_Click()" ), and then use the active cell (before the button was clicked) in a String variable for another part of the code.

Is this possible?
What commands would I be looking to study to shed some light on this?

**Ron Coderre** · 02-17-2014, 04:22 PM

Does this code help?

Please Login or Register  to view this content.

**Darth269** · 02-17-2014, 04:34 PM

That's it, thank you Ron.

**Darth269** · 02-17-2014, 04:40 PM

Originally Posted by Ron Coderre

Does this code help?

Please Login or Register  to view this content.

Hi there People/Ron,

The above code is SOOOOOO close, but this address it's assigning to the string has $ symbols with it, i.e. "$A$1", is there a way to set it as simply "A1"?

**Ron Coderre** · 02-17-2014, 05:28 PM

Here you go...try this:

Please Login or Register  to view this content.

**Darth269** · 02-17-2014, 06:37 PM

Originally Posted by Ron Coderre

Here you go...try this:

Please Login or Register  to view this content.

Man, you're awesome, thank you.

Need to pass the active cell to a String Variable

LinkBack

Thread Tools

Rate This Thread

Display

Need to pass the active cell to a String Variable

Re: Need to pass the active cell to a String Variable

Re: Need to pass the active cell to a String Variable

Re: Need to pass the active cell to a String Variable

Re: Need to pass the active cell to a String Variable

Re: Need to pass the active cell to a String Variable

Thread Information

Users Browsing this Thread

Similar Threads

Pass Cell Values in a Dynamic Range to String

How do I pass contents of a cell to a string and then use that string value to search

Pass combo box value to string variable in module

pass cell value as string to function

Pass multiple characters to a string variable

Bookmarks

Bookmarks

Posting Permissions