trigger

Hi all, I'm using the macro below to detect cell changes in a column. If a change is detected, the address of the change is used to build an array of related rows to which I want to apply another macro. This is working beautifully when I either enter a value in a cell or clear the contents of a...

Hello: I need help in completing a macro and incorporating it into some existing code that does function as designed. It's close to working but I haven't been able to get it right. The 1st part of the code adds a hyperlink (and it works properly) see below The 2nd part is the problem, I'm...

Hello: can someone help me with VBA Code to do the following: On Sheet 2, after an entry is made in Cell P an event is triggered that will copy cells P and Q (in the same row) only if Cell C in that row = "Task Summary" (note on sheet 2 there is a log no. in cell A) then on Sheet 1 this info...

Hi, The situation that I am facing is that identifiers that are entered into a column are used to search a database and display data in other columns. However, when a number is entered that starts with a zero, excel automatically truncates the number to omit the zeros. I am attempting to use...

I'm creating a macro that automatically creates a Gantt chart and fills in the procedure steps. Since the object I'm tracking is standardized, I have a large database that contains all part numbers and the corresponding procedure steps. My macro first takes in user input to enter the part...

Hi All, Hopefully there is a simple solution, maybe just a check if nothing is changed on the pivot... (?) The simple code below refreshes several pivot tables, which are linked to an OLAP Cube. I would like to add a piece of code in, so that if the User doesn’t have access to the OLAP Cube...

I'm running XL 2003 and I'm having some issues trying to get XL to automatically change the text in a button based on the user's choice from a ComboBox on an XL worksheet. I'm trying to get the number ouputted by the ComboBox (i.e., the "cell link") to trigger the Worksheet_Change event but...

I'm creating a "smart" search that will do a search after a user types anything in a cell. So whether it's two or three characters or several more, I want to call a macro. The outcome would be similar to the Google search page. Any ideas how to call a macros based on a user typing in a given...

Hi All, I have a challange!! I have an excel sheet where autofilter are avalible to use , while caculation is set to manual, I need to identify & avtivate vba code when any autofilter is triggered, does anyone have any suggentions how this can be done?:confused:.

I am writing a tutorial about using time in Excel on my blog and I made a clock in Excel which can be started and paused from the same button using the following code : Dim RunClk As Boolean ----------------------- Sub RunPauseClk() RunClk = Not (RunClk) Do While RunClk = True DoEvents...

I have the following macro, which modifies a chart when the worksheet is recalculated: Private Sub Worksheet_Calculate() Sheet1.ChartObjects("Chart 1").Chart.Axes(x1Value).CrossesAt = Range("Base1") End Sub How do I get this macro to run ONLY when a data table is recalculated with F9 or...

Hello, I have a formatting Macro I would like to be able to trigger automatically as soon as some numerical values populate the to be formatted columns. Is it possible? How can I do ? Emile

Hello, Please refer to the following image as I describe my issue. First off, a description of what you see. This is a sercive sheet given to the service technicians of a ventilation company. They are supposed to follow the list of service objects according to the description (called...

Hello, I have a Spreadsheet where: Column B = Project Number Column C = Project Title Column D = Workstage Column E = Workstage Description I have code that will sort what can appear in workstage(D) depending on whats selected in Column A. this is done using the active cell at the time...

I would like to trigger a refresh using excel VBA to trigger a refresh whenever sql data (connected to Excel) changes. Currently I rely on polling with a minimum refresh interval: 1 minute. There are loops to refresh every 200 milliseconds. I'd like to eliminate the polling and loops and have...

I write proposals for a services company. My budgets can have 10 services, with 80 rows per service. Often, not all services are needed. I would like to create a way to only expand only the service categories needed. I would like a cell to trigger this to open (currently each service area is...

I have two radio/option boxes linked to a cell e.g. A1 When I click the different option boxes the values changes (0, 1 or 2) I want to trigger an event when the value in A1 changes (when an option is selected) I have tried _______________ Private Sub Worksheet_Change(ByVal Target As...