+ Reply to Thread
Results 1 to 2 of 2

how to make condition on every cell using vba?

  1. #1
    Valued Forum Contributor
    Join Date
    09-04-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    463

    how to make condition on every cell using vba?

    I have attached my excel file in which i have following coloumns and one button.
    [table="width: 500"]
    [tr]
    [td]Date[/td]
    [td]name1[/td]
    [td]nameamount1[/td]
    [td]name2[/td]
    [td]nameamount2[/td]
    [td]Lr1[/td]
    [td]Lramount1[/td]
    [td]Lr2[/td]
    [td]Lramount2[/td]
    [td]Narat[/td]
    [td]vty[/td]
    [td]BN[/td]
    [/tr]

    and i have put my query in this file:

    any help will much apreciated.

    Regards
    CA mahaveer Somani
    Attached Files Attached Files

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: how to make condition on every cell using vba?

    Hi CA mahaveer Somani
    This Code appears to work on your Sample File
    Please Login or Register  to view this content.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ 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. Replies: 0
    Last Post: 03-08-2013, 06:34 AM
  2. VBA for Make a cell blink if Condition True
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2012, 03:22 AM
  3. help with condition /need to make ranking/
    By nitr0 in forum Excel General
    Replies: 20
    Last Post: 08-11-2010, 04:16 PM
  4. make textbox visible on condition of combobox selection
    By zebra in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-17-2009, 10:48 AM
  5. hide columns on condition:make a macro
    By Harry May in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2007, 09:26 PM

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