options

I am completely stumped. I assigned ctrl+v to a macro in Excel and now I want to switch it back to the preset "Paste" function. To my surprise, I cannot figure out how to do this. I have searched all over the web and very few even recognize my question, much less have any meaningful advice...

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

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

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

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

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

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

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

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

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

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

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

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

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!

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

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

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

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

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