selected

Hi, Drop down list value is in D2, based on that value it will autofill range B2:B31. If the value selected in D2 is 24 then Autofill range B2:B31 to 24,48,72 to 720, same as when selected 30 then 30,60,90 to 900. I would like to do this in macro. Thanks

Does anyone know if there is code to lock the ribbon so that none of the tabs can be selected? Or even hidden and locked?

I have two listboxes, lboFY and lboCY. If the use makes a single select or multiselect on lboFY, I want to clear all selections that may have been selected in lboCY and the other way around If the use makes a single select or multiselect on lboCY, I want to clear all selections that may have...

Hi, I have two columns one with a product category (A) and the next one is sub-category (B). I created a dependent validation between these two columns. A - Laboratory, Chemicals Laboratory - Microscope, Other equipment Chemicals - chem1, chem2, chem3 I selected Laboratory under A and then...

I have a list of all the worksheets in my workbook on tab 1. I want the user to put a number next to the sheet in column B and have the macro copy the selected worksheet one less times than the number listed. If in the end I want 3 copies of the worksheet, I want to make two copies of the...

Hello,</SPAN></SPAN> I got lottery results in the cells C6:J1000, I want to copy few columns as per my prior selection, for example I want to be coped only those column which I selected marking "X" in the cells C4:J4 in the example there are 5 selected out of 8 which I need to be copied and...

Hi, I chanced upon this product selector. Values will depend on the choice selected, may I know how to do it? Thanks, https://www.dropbox.com/s/5jd8kus6f3p21hh/Product-Selector.xlsx?dl=0

I have two listboxes Items for Selection (this is a multi select) Items Selected When all the required items are selected the user will click a button to send them to the Items Selected Listbox. When they appear in the Selected listbox I need them to be in alphabetical order and as I am...

Hi folks, I'm trying to write a macro to allow users to change the colour of a selected tab on a protected worksheet. My plan: • Use an input box to get the tab name from the user and assign it to a variable • Present the user with the colour palette to select the colour (standard or custom) and...

Hello, I have an Excel Workbook that has five separate sheets on it, and on the sixth sheet I would like to be able to select 2 or more (3,4,5) of the sheets independently and see only the values that appear on the sheets selected in a dynamic fashion. I think I know how to do it as a one time...

I am trying to get this code I found online to work for my need and cant figure out how to combine it. The first bit Sort_Selection works great to sort by value, but I need to sort by font color of selected range. This code is really terrific in that its not specific to a sheet name and such and...

Hi, Is it possible for a simple code for which when the worksheet is open the first entry in the drop down list is selected. have a nice day.

Hello friends, hope all is well! The below codes are working, but not as desired. What is needed: a. Code moves from one sheet to the other. b. Every time a new sheet is selected a countdown loop (5-0) in cell H2 takes place. Once countdown...

HI All I created a userform and added buttons to open different sheets. they seem to work OK ,but the form is ALWAYS on top .' How do I get the form to the back and the selected sheet to be active? TYVM

Hi, In VBA, I'd like to add date from A1 to my selected cells. I can do it if only 1 cell is selected; but when it comes to a range like "a2:a5" I can not! And there is one condition: If selected cell(s) is empty then copy the date from A1 but if not then join the dates of the selected...

Hi I looked at other threads that cover this but can't seem to get any of their suggestions to work. I have a cell K14 that has a list of 3 options: Pre_Finished _2_Pac Veneer I have a check box that i want to hide when "Pre_Finished" is selected but available for checking when "_2_Pac" or...

I have a userform that I load but the combobox is selected... I don't want the cursor blinking in my combobox when the userform is opend. I currently use sendkeys for Tab as it will move the selection to the next button which is fine. Is there a different way to code this rather than having to...

I've vigorously searched online and can't find anything to help with my formula dilemma. I need a formula to search a column/range for any cells (1 or more) with [value], to return (a single selected cell) as true/[value]. I want the formula to ask the question: does any of the cells (1 or...

I need some help with combobox's it's my first time Using those on Userform. 1. Combobox1 should look at Column "E" for Cell with "1" to "7" ---> "1" from E325:E452 (it's for the first 128 Players in Cupsystem)...

Hello, I'm looking for 2 formulas to identify: 1. Column header for selected cell. 2. Row header for selected cell. Example: <tbody> Jan Feb Mar Apr Company A 1 2 3 4 Company B 5 6 7 8 Company C 9 10 11 12 Company D 13 14 15 16 </tbody> If the value selected is 10, I want cell F1...