selection

Hi Friends, I have a Userform with a combobox "cmbchart" and i have a sheet with some charts , "Charts". In the comboBox there should be 3 Chart type listed, Column Chart , Bar Chart, Line Chart . Based on the user selection my chart in "Charts" sheet should be changed (Column,Bar,Line...

I have a combo box that has a ListFilledRange property value of a particular column in my spread sheet. My code is fairly simple after this... Private Sub ComboBox1_Change() Me.ComboBox1.DropDown End Sub Can anyone tell me why when I click on a combo box selection from the scroll down...

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

Hi, I need a combobox_Change() code that will update my textbox1 that when I make ANY selection in my combobox, it will add "+1" to my textbox. Events - I select a combobox selection in cmb1 and in textbox1 it just says "1". I select another combobox selection in cmb2 and in textbox 1 it...

Hi, hope someone can help me here. Im trying to crate a sheet that creates a dropdown of roles based on the selection of a department. Example below of what I’m trying to achieve. https://we.tl/t-oFAukUJE6p Thanks!!

So I am trying get a range to populate based on the selection in a single cell. So in the pic below, i have two types of projects. Admine Projects and IT Projects. They have different cost categories listed in column A and B. Cell D2 is a data validation where you can select either "Admine...

Hi, I'm needing a way to go an extra step after a selection was made in a combobox for a user. Example: I'm having the user choose a 3 letter acronym and this will designate a defining pallet to a location.. (We're a shipping company) Once this 3 letter acronym is chosen it will bring up...

i have this code Sub taskstime2() ' ' taskstime2 Macro ' ' Keyboard Shortcut: Ctrl+t ' Dim myCells1 As Range Set myCells1 = Selection Windows("5. schdule.xlsm").Activate myCells1.Copy Sheets("1. schdule").Range("hm" & Rows.Count).End(xlUp).Offset(1, 0) End Sub it takes...

Guys. What am I doing wrong, please? I need a VBA message box to pop up if and when a specific cell has specific text in it as follows: Private Sub Worksheet_Calculate()If Worksheets("Home Quote").Range("D33").Value = "Selection Error" Then MsgBox "Please make another selection" End If End...

I have a listbox in my userform. Its set us as a single selection. When the user clicks on it, they complete som data manipulation, and then the selection is eliminated from the listbox. I have run into a problem. As the selections are removed one by one, eventually there is one left. It gets...

Hi I wrote the code below to change the color of each cell in a selection. Do you think it is good and efficient code? How you would do it yourself. Thank you so much. Sub myselection() Dim xcell As Range Dim i As Integer i = 1 For Each xcell In Selection...

Hi, I have an issue with CTRL+SHIFT+ARROW, excel selects the column/row content, by it doesn't change the view to the top/end of the selection (eg: if I want to select all column A and I have 312 down rows, CTRL+SHIFT+BOTTOM ARROW selects all 321 rows, but my view remains where I started my...

Hello everyone, I have this VBA code which works great, I am trying to include rage selection. So in order words I want it work like the Sub send selection code. How to I incorporate the sub selection code with the below code. Sub Send_Email_With_Signature() Dim objOutApp As Object, objOutMail...

I would like a macro to sort fields in the current selection ( selected before running macro). tks

<tbody> Data Filter selection Jan Jan NowJanuary Feb RatJan Febby NowFeb </tbody> Hi Want to use Advanced filter whereby it filters using part supplied selection entered in the same sheet finding & filtering to all data that include this partial data Based on...

1 other thing I am playing with, I am trying to choose the row with the latest data for a userform that displays the information. The ID for the item may be duplicated from a different day, so I need to make the selection only pull the current data defined by a date in row A. any ideas?

I'm looking for a way to setup a drop down menu that will give a sub menu depending on the primary menu selection and i need the sub menu item to be removed after it has been chosen. But, if I check a box that turns a cell to a TRUE value it will allow the sub item be used again (add it back to...

Hi Mr. Excel Family, I know I am overthinking this and its probably simple so here goes: I am trying to set "ChartRange" as a range that includes cells H5:K5 and everything below as the range of cells to use in a chat. For some reason, I can't figure out how to select the original range and...

Hello! I am playing for first time with userforms in VBA. I am trying to have 2 users forms: the first one to select a group of rows ("modules") to be deleted, and the second one to confirm the deletion. I want to see the result of the selection in the first user form in the second user form...

Hello. I'm not 100% sure if what I'm trying to achieve is possible in the way that I'm trying to do it, but any guidance on how to start would be much appreciated. Basically my goal is to create a workflow chart to standardize the tasks for specific processes. I have the column "Tasks" B:B...