View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jhahes[_30_] jhahes[_30_] is offline
external usenet poster
 
Posts: 1
Default assigning a macro to a cell?


Can I do the following. I am a novice in VBA. I will try to explain t
the best of my ability.

In Sheet1

I want the code to start in J2 and search down all of the column unti
J200. If it finds the words NEED TO PAY, then put a command button o
anything that can run an assigned macro in the corresponding colum
(K). So if the loop or code finds the words NEED TO PAY in J10 i
would put a button or someting in K10 that would run a macro(have th
ability to run a macro, don't run now), only if it is clicked.

Any help would be wonderful,

please let me know, I probably didn't explain very well

Thanks
jos

--
jhahe
-----------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...fo&userid=2359
View this thread: http://www.excelforum.com/showthread.php?threadid=46837