select

Howdy all, I need some assistance to make this macro more streamlined. I have a worksheet that has certain cells that are input cells, but I want to have text in the cell that reads "Please Select Program" What my simple macro skills have allowed me to do is the following: The code is input...

Hi Why when I enter 66 as a number, this code print "Else"? it does not go the first case? any idea why? I used F8 but again jump to the last case. Thank you very much. Sub test3() Dim x As Integer x = InputBox("enter number") Select Case x Case x > 50 MsgBox...

Hi all, So I am writing a code to select multiple columns. Here is what my code would look like: Columns("B:B")... Columns ("E:E")... Columns ("H:H")... Is there an easier way of selecting all of those with only one "Columns"? The ... is there just for the example. Thanks in advance.

This is the start of my select case statement and it has an error and I can't figure out why, can someone help me please? Dim printWorksheet As Worksheet, logoShape As Shape, tempImageFile As String Dim city As String Set city = ThisWorkbook.Worksheets("Start_here").Range("H9").Value...

Hi, I have 2 listboxes (ListBox1 and ListBox2). When I select something in listbox1, listbox2 deselects and vice versa. I have tried these in listbox1 and listbox2 change and click events: ListBox1.Selected(ListBox1.ListIndex) = False and ListBox2.Selected(ListBox2.ListIndex) = False They...

Hi I have lets say 5 cells. The first one has an email address in hyperlink format (blue underlined). How can I select these cells (highlight them). when I click on the first one it will open the email address. It wont allow me to select cell A1. So I went to A5 first, selected it then drag the...

Hello I am so glad to find this forum, might question might be super easy for most of you but I am beating my head on a wall from last few hours so thought to register and raise it here I want to Select the month in month total say March it gives me No. 3 and in YTD total is I select Mar 16...

Trying to create a new Access table based on the results of 2 join queries (see below). Each query individually runs fine with no errors, but when I use UNION I receive an error message "An action query cannot be used as a row source". Can someone help? Thank you! CODE: SELECT...

Bear with me as this is not my forte with Excel! I am composing a simple excel sheet for users to complete, I have started using check boxes but what I need is if a user ticks a box, they have to select an option from a list, and the response is populated in a cell somewhere. I know how to use...

Sub TestIndex() Dim arr, List$, i% List = "10,12,14,16,18" arr = Split(List, ",") For i = 10 To 18 Step 2 Select Case i Case LBound(arr) To UBound(arr) MsgBox arr 'Here, I want msgbox show say 0 to 4 End Select Next i End Sub So when...

Hi, Is there a trick outside of the Pivot to select the items in the search option by linking it to a list? I have 10 pre-defined items to select in the search bottom. I keep adding them using "Add current selection to filter". This is tricky and time consuming. Just wondering if you can help...

I have a macro that prompts a user to select a file that is subsequently saved as a sheet and the data used in calculations. If the user cancels at the prompt to select a file, how do I avoid an error and just exit the macro? I suspect it's something to do with OnError, but don't know the...

Hi and thanks in advance! Imagine I have a Path and a String: wPath = "C:\Users\MrExcel\Desktop\Works" wName= "France" I would like to prompt the user to select any Excel file within the Path = wPath containing the Name = wName I know How to prompt the user to select within the Folder wPath...

Hello guys, I have got a questions regarding different calculations based on the selection of the drop-down list. In other words, how can I have different calculations based on what variable I select in the drop-down-list? For example, let's say I've got 5 companies and I created a drop-down...

The challenge gets tougher and I have to call on Tech support:) When I click on a command button, I want to access the open dialogue box where I select an image file from a folder - this could be anywhere on the computer. Then I rename that image with the content in textbox1 (for example)...

Hi, Is it possible to create code to highlight the row of the selected cell? I use two screens so even if I select the whole row when I go to my second display excel doesnt show the highlighted row when I select a different window. I was hoping it was also possible to have a macro that...

Hello, I created a form whose value could be edited via userform. in same userform, there is a cell that shows the result of that calculation. how to make it dynamic? 'Diğer değişkenler için burayı planladımPrivate Sub tbBINR_Change() Select Case tbBINR Case "<1,7" X = 1...

Dear MrExcel, I need to coloring textbox based on its value. I've tried to write the code below, but it wont works. If value = 0% then backcolor is Red If value > 0 and <= 50% then backcolor is Yellow Else backcolor = Green Can somebody help me? Private Sub Train3_Progress_Change()...

Hi, I am trying to find a code which will select the next available empty row down the spreadsheet and then select columns A to D of that row. Could anyone help me out with this please? Many thanks

Good morning, I'm trying to write a function to search and replace, thus: Set AnimalColumn = Sheets("Database").Range("Col_AnimalType") ReplaceWithSpecies AnimalColumn Function ReplaceWithSpecies(RangeToProcess As Range) With RangeToProcess Select Case UCase(.Formula)...