+ Reply to Thread
Results 1 to 3 of 3

set value in one cell based on value of another cell

  1. #1
    Registered User
    Join Date
    07-12-2012
    Location
    Quakertown, PA
    MS-Off Ver
    Excel 2003
    Posts
    5

    set value in one cell based on value of another cell

    Here is what i want to do.
    If the value in A1=1 then set the value of B1=1.
    The problem I am having is there is another macro that says if B1=1 then hide row 10. The macro I wrote will put a 1 in B1 but it does not activate the hide macro.

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: set value in one cell based on value of another cell

    Why not just make the code hide row 10 if A1 is 1?

    Why don't you start with explaining the big picture.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,097

    Re: set value in one cell based on value of another cell

    A possibility perhaps could be
    In the sheet code put
    Please Login or Register  to view this content.
    and in a module put your macro to hide row 1à
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Delete row based on cell FORMAT (color, font, etc) (not based on cell value)
    By trobey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2012, 10:39 AM
  2. Replies: 1
    Last Post: 03-05-2012, 04:28 PM
  3. Replies: 3
    Last Post: 07-15-2010, 08:49 AM
  4. Replies: 0
    Last Post: 02-11-2005, 02:06 AM
  5. [SOLVED] data validation to restrict input in cell based on value of cell above that cell
    By NC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2005, 04:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1