User Profile

Collapse

Profile Sidebar

Collapse
66Nana
66Nana
Last Activity: Sep 25 '13, 10:20 PM
Joined: Jul 19 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • 66Nana
    started a topic Excel If and Vlookup
    in Visual Basic

    Excel If and Vlookup

    I have a drop down box where users select a Town. I have a formulae that says VLOOKUP(A13,Tra velRates,2. A13 is the town from the drop down list. This works fine and a rate is calculated. However, there are 3 rates I need to use depending upon mileage eg 50-99, 100-200,201-300. I think it is =IF then vlookup but I am completely lost. Can anyone PLEASE put me on the right direction.

    A huge thank you in advance
    See more | Go to post
    • 66Nana
      replied to Excel Radio Buttons
      in Visual Basic
      A huge thank you to you "Rabbit", I changed all of the radio buttons to checkboxes and it works!!
      See more | Go to post

        Leave a comment:

      • 66Nana
        started a topic Excel Radio Buttons
        in Visual Basic

        Excel Radio Buttons

        I need to setup a table in 3 columns (that is fine) but in each row there needs to be radio button. I know how to insert the radio buttons. However, I need the operator to be able to select say 2 or more radio buttons, not just one. I a using Word 2010. Any help MOST grateful.
        See more | Go to post
        No activity results to display
        Show More
        Working...