options

  1. S

    Multiple Lookup Values

    Hi, I have two tables similar to the following: 1. <tbody> A B C D E F G H Code op1 op2 op3 op4 op5 op6 op7 1 ABC123 XY none ZZ WR none none LUG 2 XYZ789 none none ZZ none LUG XY none </tbody> In this table each of the options has a drop down from a defined list. 2. <tbody> A B C...
  2. D

    Excel tab menu options some greyed out?

    Hi I have a work book with many tabs, Excell 2019 the book or tabs sheets are not protected. The menu options (all except 3 of) in the tab menus are greyed out. Can anyone assist as to why this is? Note it is only this one workbook as with other workbooks it does not apply. Regards
  3. I

    Hide combobox entry options please

    Evening, I wish to hide two entries in a combobox. Please can you advise what options are available. The two entries in question must be in the combobox BUT not shown. Deleting these two entries isnt an option
  4. K

    help with vba copy from one worksheet and paste in another

    I'm trying to learn VBA but, haven't been able to get my code to work. I have a worksheet called Leases. In column "F" of this worksheet I have a dropdown menu with "Yes" & "Question" as the options. I want to copy the entire row (cells A - J) if cell "F" contains either of those options. Then...
  5. M

    Fill Series greyed out...

    My situation Brand new workbook All options checked/selected: a. Options>Advanced>"Enable fill handle and cell drag-and-drop" b. Options>Advanced>"Show quick analysis options on selection" c. Options>Advanced>"Enable AutoComplete on cells values" d. Options>Advanced>"Automatically flash fill" e...
  6. J

    Toggle Button 3 options

    I need a macro to assign to an object button (Shape) when pressed it will toggle a specific cell value to change between PLANNED, IN-BUILD and COMPLETE. I have this code but it only gives me two options Any Help would be appreciated. Regards Jason Bing Private Sub CommandButton1_Click() With...
  7. H

    Special options on userform

    this is a very special settings I need for this task ... but it requires many setups i only have 1 Userform for a Main Matchlist but i know there will Be 127 Match's in my Knock Out system "CUPGAME" The Main Matchlist is Take action from the combobox'1 to set Players in to the Game and Referee...
  8. B

    Select Multiple Dropdown Box Options

    I need help figuring out how to select multiple dropdown box options, without repetition.
  9. J

    Index Match help

    Hi! I have a formula (below) that is working when I use the exact term I want to look up (DEN C) but I would like to look up anything that starts with DEN. There should be three possible options, DEN S, DEN C, and DEN F. {=INDEX(E:E,MATCH(1,(Withholdings!A:A=Data!A2)*(Withholdings!F:F="DEN...
  10. E

    if with 3 options

    Hello, I'm trying to use if statement with 3 options with data validation. I got it to work with 2 but cant seem to figure how it will work with 3 or even if it's possible. the code I have is =SE(B5="yes";list1;list2) based on the word "yes" but I'd like to add another option to that IF. I'd...
  11. W

    Send Email choice

    I am using a macro to send emails. But sometimes I want to see the results first. I can manually reset the options to do so here by changing the remark. ' .send '<-- Send out this email .display'<-- Display instead for the debugging only How can I get a prompt like this one to reset...
  12. D

    Cannot convert from R1C1 reference to A1 reference even when options changed

    Hi everyone. I don't understand why my VBA coding is still coming out with the R1C1 reference when I deselected it in my options. I am using Excel 2016. This system is supported remotely. Can that cause my options to be ignored? I'm hoping somebody has maybe experienced the same issue and...
  13. O

    Differing drop down choices

    I have done some research and I have not been able to track down any information on the following. Can anyone offer any advise/direction? I want to provide a cell with drop down options that are base on the information entered in another cell. Is this possible in excel 2016 ? Thanks in advance!
  14. M

    Count cells that contain anything OTHER THAN - Help Please

    Hello all - Hoping you can help me out here. I am trying to count up cells that contain freeform text and can't seem to figure it out. The column is a 'How did you hear about us' list and it includes three standard options plus a freeform other field. Users can select multiple options so I...
  15. M

    ComboBox Help - Drop down options disappear/reset after clicking an option in my combobox

    I have a combo box on a userform that is connected with a formula. It's similar to an autocomplete combo box. Anyways, I have my program working fairly smoothly except for the fact that after it narrowing down my search, I will click on SOME options and it clears itself and it wants me to type...
  16. L

    VBA to open a specific template

    Is it possible to do something similar to below? Open a workbook which automatically triggers a macro. Once the macro runs a dialogue box will appear and has options of "Herds: 1, 2, 3, 4" and "Hay: 1, 2, 3, 4" You must select either 1, 2, 3 or 4 for each of the options and press ok. Once you...
  17. S

    [VBA] Loop through Data Validation and Print Output

    I have the following code with which I want to loop through all the data validation options available in the drop down list and copy/paste that output of the data validation option into MS Word. The code "works"... However, when it pastes the report into MS Word, it pastes the last list option...
  18. L

    Multiplication of values based on listbox selections

    Hi, really hope someone can help me with this one, I don't know VB at all, this is a new challenge for me and cant seem to resolve through web searching... I am using Excel 2016. So I have learned how to create an ActiveX listbox, how to populate the listbox and turn on MultiSelect. My listbox...
  19. C

    Need help with additing additional parameters for VBA code

    Hi everyone! Hoping to get some help with the following issue.. I have the VBA code (below) which will protect and unlock grouping options for a excel sheet, however I would like to add the option for user to edit/add cells, use filter options too .. pretty much get all the functionality in a...
  20. mikecox39

    Options returns me to the worksheet

    I want to set Iterations on my worksheet but when I click on File/Options I am immediately returned to my worksheet.

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top