option

  1. K

    Userform Appearance While Running and in Designer Mode

    Greetings everyone! I searched throughout this forum, and I'm sure I may have missed a similar post. If it exists, I'd be most appreciative if you'd direct me to where I may find it. :hungry: So, here's the scenario. (I) Within a userform, I have a multipage with several tabs, all containing a...
  2. G

    vlookup using a listbox for item to search for and the next column over to be an answer that changes the value in option buttons

    I am trying to have the user choose a serial number in a list and from that the option box will change. here is the partial code i am trying. lsn=worksheetfunction.VLookup(lstSN.Value,worksheets("Serial Numbers").Range("a":"b"),2,False) if lsn="" then exit sub else if lsn="25 in_lbs +/- 6%"...
  3. E

    Calculating dates using option buttons

    I'm trying to create a form that will allow the user to automatically fill in the beginning and ending date as search criteria using option buttons. Example, the user would select option buttons 1) Month To Day or 2) Last Month or 3) Year To Day or 4) Last Year, etc and the dates would populate...
  4. C

    Trouble Looping Through Option Buttons in Worksheets

    Hi All, new to vba coding and have been wrestling with an issue. I have a large workbook with multiple worksheets. Each spreadsheet has information in it contained in option buttons (I think they are the Form Control type and not the ActiveX type). I am attempting to write code that extracts...
  5. 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...
  6. H

    URGENT Help required Please!

    Hi all, I hope you can provide some urgent help. I was trying to disable the Paste options and used the following code in the Worksheet Private Sub Worksheet_Activate() Application.CutCopyMode = FALSE End Sub Private Sub Worksheet_Deactivate() Application.CutCopyMode = TRUE End Sub This did...
  7. E

    Code to switch views of columns

    Hi all, I ma trying to generate a macro that when run will offer me certain columns to view and hide unnecessary columns I have run the following using the macro recorder but this doesn't seem to worknymore Sub View_Meeting() Columns("A:E").Select Selection.EntireColumn.Hidden =...
  8. V

    Difficult one..

    Hi you all, Because i cannot insert a sample document, i will try to explain my problem.. Suppose you have an Excel sheet. In column A (from A1 till A20) you have text and number data (A1= Option 1, A2 = Option 2, ...). In column B you put 20 drop-down lists that refer to column A. So if you...
  9. B

    Multiple IF(AND Statements in Single Cell

    I am attempting to combine the below formulas into one cell in an effort to return 1 of 4 option based upon my data and criteria in cell F2: =IF(AND(E2>=TIMEVALUE("6:00:00 AM"),E2<=TIMEVALUE("11:59:00 AM")),"MORNING") =IF(AND(E2>=TIMEVALUE("12:00:00 PM"),E2<=TIMEVALUE("6:00:00...
  10. A

    Random value assign with weightage

    I have a sample size of 30. I need an excel function in which I can assign " Random Values " (say a question has 4 options and need to assign 1 to 4 randomly) based on the weight to each individual from the sample. Means Option 1: 45% Option 2: 12% Option 3: 30%...
  11. C

    Open and close field based on input of another field

    Hello, I have a Table with 11 fields. The first field is a drop-down field with two options. Lets call them option A and option B. The remaining 10 fields relates to either option A or option B, but not both. For example, if option A is selected, then fields 2, 4, 8, and 10 would apply...
  12. J

    Accelerate workbook performance without rebuilding indirect formulas

    Hi, cross post here: https://www.excelforum.com/excel-programming-vba-macros/1272727-accelerate-workbook-performance-without-rebuilding-indirect-formulas.html i am using many indirect references for listobjects within formulas. I think this is causing recalculation of whole workbook all the...
  13. K

    Conditional Additions

    I'm new here. I am wondering if anyone knows how to add and option in a column to add another column. For example, I want to record what chemicals I am applying, and since sometimes there may be up to 7 chemicals at a time, I want the option to record each one, or if there are fewer (obviously...
  14. gheyman

    Access: Refresh All

    Whats the code for Refresh all. If I use the macros its only a Refresh option. Thanks
  15. N

    Data Validation Formula for Phone Numbers

    I am having an issue with a lot of hands in the pot on the workbook I am working with. One area is the phone number area. Everyone puts it in different and I need it to show up in one format even if it is copied and pasted over with the 123 pasted option. When pasting with that option it takes...
  16. J

    Referencing an option button click between worksheets

    Hi, I've added some VBA code to update a cell value when an option button is clicked. The option button is part of a group, all events occur on the same worksheet. My code below: Private Sub OptionButton1_Click() Range("A2") = "1" End Sub I've repeated this code for all 5 option buttons and...
  17. S

    Option within Macro select wsheets when copying to a new Wbook

    Hi, I currently have the script below to copy a wksheet to a New Workbook. R9096 is 1 of 35 reports and they have their own worksheet. I would like the user to have an option of selecting the reports they want to extract. Is this possible to do within a macro? Maybe a drop menu showing the...
  18. L

    Macro - "use relative references"

    Hi Recording a macro has an option called "use relative reference". I noticed that when i use that option, the macro can run anywhere I "select" a cell. So it gives me an impression, the "relative" here meaning relative to the selected cell. It has nothing to do with relative and absolute cell...
  19. gheyman

    Filter Formula

    I am watching a YouTube video and its using =Filter to create a Searchable drop down list. But when I try to recreate whats on YouTube It doesn't like "=Filter" the only option is Filterxml which I think is completely different. '=Filter(A:A,Isnumber(search(D1,A:A))"not found")
  20. R

    make x as variable

    Hello Excel Gurus, Simple question: is it possible to make x variable using the function above? or anything text or numbers that I want to declare. not working code Option Explicit Sub test() Dim x As String Debug.Print Evaluate("=CELL(""format"",x)") End Sub working code Option...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top