LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
assigning value in macro tina Excel Programming 4 October 29th 09 03:33 PM
assigning macro carrera Excel Discussion (Misc queries) 16 March 21st 08 09:00 PM
Assigning Macro to a cell Peter[_54_] Excel Programming 2 July 29th 05 07:12 PM
assigning macro to cell Adam Excel Programming 6 April 22nd 05 05:19 PM
Macro assigning help PLEASE Jim Rech Excel Programming 0 February 10th 04 10:03 PM


All times are GMT +1. The time now is 03:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"