Unable to run multiple procedures?

[CarolineGMartin90]

Hi there,

I have two peices of code that work, however I am struggling to get them to run together. The first bit of code that changes numbers to words (i.e. "blood", "rust" etc.) is working, however I dont want users to be able to select multiple cells - only the one they are working in. However I am not able to get that aspect of my code to work in conjuntion with the other code. I have tried adding in "application.enableEvents" however I must be doing it wrong.

Any advice greatly appreciated!

Caroline

 

[Marc L]

Hi !

only the one they are working in

► Just use ActiveCell property …
​

 

[CarolineGMartin90]

Hi !

► Just use ActiveCell property …
​

Hi there!

Many thanks for getting back to me so soon! Forgive me, I am very new to VBA, and although I am familiar with the ActiveCell property I am not sure where you mean for me to use it, and how it will solve my issue of the two codes not running when they are on the same sheet?

If you could give me a bit of further explanation I would really appreciate it!

Many thanks,

Caroline

 

[NARAYANK991]

Hi ,

If you can upload your workbook with the data and code in it , you will get help faster.

Narayan