selected

Hi guys, This is my first post in MrExcel.com I've been looking for a solution in Excel 2016 to uppercase selected cells (which is easy) but I only need words which are bolded to uppercase, not all of them. Any ideas on how I can make such a macro? Help would be greatly appreciated...

I am looking for a way to check if the user has selected a single cell or single row within a Listobject. If this is the case, then I would like to return the value from Column 1 of the Listobject for the particular row. Not sure how to start with this one. any help is much appreciated. many...

Hi, I have code which will enable a button if a column is selected but the selection change event doesn't recognise when an offset column is selected via button code, is there a way to detect this offset change without clicking the column to select it? Can someone help with this please What I...

Hi everyone, For an app under development, I need the user to: 1) Select a range of rows within a single column (say, A5:A15) 2) Color the background of the selected range. 3) Click on a button that opens a UserForm where the selected range is shown ( e.g. within a text box in the UDF, labeled...

Hello, I am making a form and I want whenever a value of "yes'' is selected from dropdown list then certain rows along with controls appear (which have been already created). and whenever a value of "no'' is selected from dropdown list then those rows along with controls disappear. I tried...

Dear all, I am currently working on this code and I need to replace chr(13) with space for the selected text and not for the whole slide. The code below works well with all shapes in active presentation . The code is as follows : Sub Removepb() Dim otxR As TextRange Dim osld As Slide Dim...

Hi there, There's no easy way to get selected option of a option button in a Userform VBA besides read one by one is is true or false (checked or not)??? GroupName works only to avoid multiselection in the group? There's no "grupname.value" option. Thanks

Hi all, Is there any way to automate the copying and pasting of selected powerpoint slides via macro/vba? I have a master deck of 100 slides, however only selected slides are required to be paste into a new clean deck. Is there any way to copy the slides based on an array search on specific key...

When editing a cell's contents, you can "select" (highlight) some of the text within that cell. Is there an object in VBA that lets you reference the selected text within the active cell? The reason is that I have a spreadsheet where some cells contain names. The names need to be replaced by...

Hi, Is it possible to check if the Entire Row of Row 1 is Selected in the Selection Change Event? Can someone help please

Hi All. I've trying to code the following but not yet managed it! I'm looking to filter a data range let's say A5:C200. The criteria will be the value of a drop-down box in D1 selected by the user. The value will only be contained in one of the columns. As always, any help appreciated. Thanks

I am trying to use the Mr. Excel HTML Maker and either I am doing something wrong or I don't understand what I'm supposed to do. I downloaded the file, unblocked it, selected the Add In, went to my workbook tab and selected the cells I want a screenshot of, then clicked the User Defined...

Deleteselected Range in selected Sheets Cananyone help with a code that deletes a Range starting in "A7" to bedeleted in all Sheets except two in the workbook? Rangecan vary in number of Rows. Afterall Sheets are deleted, cell "A7" must be active on all sheets thathave been deleted...

I have inserted an excel table into my spreadsheet and I need to be able to update all rows of the table in column M with a 1 if a checkbox isn't selected and a 1.1 if it is selected. The table starts in column A and it is called npss_quote. The checkbox is called chkincrease. Can someone please...

Hi, I'm very new to VBA and was wondering if somebody could help me with the following I have a user form with multiple combo boxes and text boxes. One of these combo boxes has three options, all entered via VBA If the option of Hotel Supplies is selected (and only this option), I want to...

Greetings. I have a spreadsheet to calculate incentive pay based on title. The title is pulled from a data validation list in cell F7. There are 10 possible titles and when selected, i want a variety of ranges of rows to be hidden. The hidden rows may be different for multiple titles. There...

Hi all. I have the update form with a combobox that lists all names on spread sheet. Once one is selected it then populates the entire form with remain data in accordance with the name that was selected. Now, when I click on the update command button, I'm getting an error. I am watching this...

Hi All, I am having trouble getting this to work. I am close, but probably missing something. I am trying to play a wav file when the active cell is U18. When the user selects this cell, I want the audio file to play. When I use the code below, it works when I have the cell selected and run the...

Excel Guru's, I have a beautiful opportunity calculator that I've recently built. I contains a list of markets, for which I have a Slicer (from data pivot table). What I can't figure out is how to write a macro that automatically resets data in 11 specific cells when a new market is selected...

I am using a dropdown list from G16:G2006. Within this list is the option of ‘Cancelled’if this is selected I want anything entered in the corresponding cells in columns ‘N’ & ‘O’ to be automatically deleted and the cells then left blank. I considered having the formula placed in cells...