CONST range macro run functions based on range

[jdeverich]

Hi Guys,

The idea of the macros below is this.

Macro1:
when you click on any of these cells place user info in a cell

Macro2:
When you click on this other range of cells change the value of this cell to something else

The problem is making both work in one sheet, if you can think of a way to do this I would appreciate your help.

Regards, Jaems


Macro 1:

Please Login or Register  to view this content.

FYI esigncell is just a public function to pick up some user info as follows

Please Login or Register  to view this content.

Macro2

This code also works but I want the two combined for one range do the below, for the other range of cells do the one above.

Please Login or Register  to view this content.

[pike]

Hi jdeverich
Try something like....

Please Login or Register  to view this content.

[jdeverich]

Access form Template - upload.xlsm

I think we are getting closer however somewhere the code is missing the priciple only to look at the target cells, this is where I got stuck also. The function starts looking at every cell not just the ones selected in the range.

If anyone has an idea appreciate the help.

Regards, James.

[pike]

Ho Ho Ho

tested this one

Please Login or Register  to view this content.

[jdeverich]

Access form Template - upload.xlsm
Hi Pike,

Still having trouble think when I take out the "const as string" expression the function stops continuing to watch those cells waiting for someone to click on the cell. So when applying the set caommand as your alternative nothing happens when you click on the cell, the cell is no longer working like a button.

Tricky one!

Regards, James.

[pike]

which cell?

Please Login or Register  to view this content.

[pike]

It works for me in the cells in the intersections

[jdeverich]

Really? In my sheet it seems to run both functions regardless which cell I click. If its not too much trouble would you mind to upload the file you tested on?

Thanks Heaps!

James.

[pike]

Try this the attaachment .. If it dosent work I dont know what you are doing so can you expand on the explination

Please Login or Register  to view this content.

Access form Template - upload2 Test.zip

[pike]

are your named ranges in esign correct?