switch

Hi All I have created a dashboard using excel. I will be displaying the dashboard on anoffice TV. I have around 5 differentworksheets on the dashboard and I want to switch between the worksheetsautomatically say every 10 minutes and loop back to the first before repeatinguntil the...

Hi , Is there a way to remove variable text from a string in a cell, there will be variable rows of data that may or may not contain the W/MW values, and it's not case sensitive either. Can someone help with this please From this <tbody> Voltage Switch 1/16W Ceramic Wirewound Regulator...

Hi all, I am trying to automatically convert a few 'durations' (in [h]:mm format) located at range D17:D21. I need to use some toggle switches at E16:I16 to select what ratio to be displayed at cells E16:I16. e.g. at E16, the switch should either show Ratio 0.75:1 or Ratio 1:0.75 and that way...

Hello all does anyone know how to add a multiple IF test in one line of a SWITCH statement? I am testing for amounts but sometimes need to check other parameters as well. My example is: Test:= SWITCH(TRUE(), values(Table[Amount])=0, "No Sale", values(Table[Amount])>=100, "Large sales"...

hi, I need to refresh Query (PQ) after file saving. Is there any way to check if is fully saved before executing next line? In below code if any user would switch sheets very quickly I get run-time error. Private Sub Worksheet_Activate() ActiveWorkbook.Save ActiveWorkbook.Connections("Query...

Hi, Excel 2016 rolled out many new functions such as SWITCH, TEXTJOIN, etc. Unfortunately, these functions are not available for non-365 subscribers. I was wondering if somebody built a VBA UDF for SWITCH already? Its syntax is the following: Syntax SWITCH(expression, value1, result1...

I was just curious if it was possible to turn this statement around. For example if I am in cell C2 and I want it to place the proper of john smith (which is in C1) in C2 I would type =proper(C1) and it would place John Smith in C2 what I was wondering was if it was possible to somehow switch...

RE: Count if Hi All I need some help if you dont mind, I have a sheet called "Detailed NTWK (LAN) HW Status, and on there is two columns: - F3:F60 - Core Switch Model - This is a drop down box for selection G3:G60 -Core Switch Quantity - This is a drop down box for selection H3-H60 -...

Hi All I need some help with a formula if you dont mind.... Bascially I have a Sheet called "Detailed NTWK (LAN) HW Status" and within that a column called "Core Switch Model" (Cell F3:F60), next to that there is a "Core Switch Quantity"(G3:G60). Both of these columns have data validation list...

Hi Guys, I have a function on Module.I'm planning to have a ActiveX combobox on sheet 1 with a list of values(ie : 1-1s etc) when the user selects any value that should trigger/invoke a function below is my code. Private Sub ComboBox1_Change() Set comboVal = ?? Select Case...

I have a sub that optimizes performance by shutting off certain functions (.ScreenUpdating, .DisplayAlerts, etc) at the beginning of a sub or function and turning them back on at the end. It works great and I have it in almost every sub and function I've made. However, when it's run in a...

Hey There, Currently I am using this formula: =SUMPRODUCT(IF(MOD(ROW(C12:C)-ROW(C12),12)=0,IF(ISNUMBER(C12:C),IF(C12:C-DAY(C12:C)+1=DATE(2017,8,1),C4:C)))) Which works great; however, when I try to get all the data from the whole year and switch to...

Hello all, I have a shortened version of my formula, and I wanted to see if anybody had an easier way of doing this. I've got another 30 rows to add to the formula, and I haven't had much luck doing a range...

is it posssible to do not work right click on sheet?

Hi Folks, I have the following formula in VBA which is getting a run time error I think because the formula exceeds 255 characters. I understand there is a way of breaking up the formula and was wondering if anybody would be able to break up the following so it could run in VBA. Thanks...

Hi, When I want to edit the table properties of my SQL table in Powerpivot, I used to be able to preview the table. Now per default I have the query editor and the options are greyed out. I already found on the net that this is a bug, but I can't find how to solve it. Can anybody help? Thanks...

Hi guys, I have a workbook with a series of worksheets, each of which has an ActiveX listbox in the top-right corner. The listboxes are dynamically populated by a single public function which is called from the Worksheet_Activate event of each of the worksheets (The call passes the listbox...

I have a large workbook of 70 pages containing many arrays. Only after enabling macros, does the workbook give #Value errors. The workbook contains the following Switch to break iterative calculations: =IF(Switch,AVERAGE(+CashMonthlyBf,+CashMonthlyCf),0) The workbook opens with the...

Windows 10 Home with Excel Office 2010. A macro that has run for years, now intermittently stops working when the Windows(WorkbookName).Activate command does not switch windows. The following Sheets command fails because the window didn't switch. One suggestion that seems to help is turning on...

Hi I am trying to avoid using "Data " I need to use Data! without the "". Is there a way to do these formulas different and work the same way. Maybe not using the indirect way. Reason cause I ahev to switch the sheet name sometimes and the " " mess it up thanks =INDIRECT("Data!$E$2")...