option

Hi all, I try to understand why my code to clear option button does not work. I know how to clear listbox or textbox from userform, code below ListBox2.Clear TextBox1 = "" But from various optionbuttons in frame, it does not work Here I have 2 frames, with 4 option button in the 1st...

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...

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%"...

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...

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...

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...

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...

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 =...

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...

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...

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%...

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...

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...

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...

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

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...

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...

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...

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...

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")