reset

Hi, Please can someone help me? I have a userform called OPTIONS. I have 6 different options on the userform. What I would like is if an operator selects an option it counts the number of times that selection has been selected in a textbox on the same userform. For example: If...

Hello all, I got a combobox on my userform named cboxFunctionSearch This combobox is filled with the following code; Private Sub Init_cboxFunctionSearch()Dim X As Integer With Me.cboxFunctionSearch .Clear .AddItem "All" For X = 0 To Me.lstSearchResults.ListCount - 1 Call...

I have created an Active x control reset button on a worksheet to clear certain cells. I have tried to create another reset button, yet when I do, it has the same cells listed to clear, but doesn't work. And when I make changes to one button, it changes the contents of both. How can I create...

I have looked, lo, through these internet meadows in hopes of finding something that speaks to a reasonable solution. I have inherited a workbook that I have been told needs a new, 5th, slicer added ( YAY! ), but need to exclude it from being reset when the other 4 slicers are. The code...

I have three columns articulated as below: Cetegory | SubCategory ID | Subcategory Cat 01 0001 SubCat1 0002 SubCat2 Cat 02 0001 SubCat3 0002...

This is a clean code question: I have always been taught that after setting a range in vba code, that to free up resources I need to reset the range object back to Nothing after I have used it (eg Set MyRange = Nothing). However, when I set a range in the return value of function I do not seem...

I have searched the forum and could not find a resolution that works. I am a newby when it comes to working with VBA and Macros so please excuse my ignorance. 64-bit operating system with Excel 2016 32-bit I have a workbook with 3 worksheets. Sheet one contains a table with filters turned on...

I have a macro which, among other things, draws a smiley face ( :cool: ) from the Insert + Shapes menu after a positive event. I have a reset all button to remove the data generated by the previous macro AND remove the smiley face. However, the smiley face keeps changing name from similey...

Hi I've got a list in which I need to sum values (including blank cells) in a row , until I insert a condition 'x' which resets the count. The columns go by Weeknum and day, and in a cell (at the end of a year) I need a formula which can calculate this, as per the example CW-1...

Hi all Does anyone know if there is a way to have a button to 'reset' a spreadsheet to the values it has upon opening? For background the spreadsheet will have a number of graphs present that are pre-populated. Sliders etc will be used to change values and visualise how these will change the...

Hello All, I need a little help. I am using four combo boxes from the data ribbon Controls-Insert-Forma Controls Combo box (Form Control). All four have a cell link that provides a number based on each selection. So when Select a value on my 1st box, the 2nd combo it is populated based on...

Hi Everyone, I'm working with Text and Combo boxes on a Tabstrip in a Userform. I have multiple Tabs on which the user will input data and then click a button to write the data to various worksheets. So far so good. My problem is that because Tabstrips share the same controls I want to reset...

I have a spreadsheet that we use quite often, and am trying to make it a little more "user-friendly". So, to facilitate rapid-resuage, I inserted a Command Button (ActiveX Control), named it "Reset Form, and have this as the code: Private Sub CommandButton1_Click() Range("C3").ClearContents...

Hi All, I have created a small excel sheet to embed into my web page, I have chosen to embed it using Onedrive as it seems the easiest way (copy and paste some iframe text) My problem has occurred when I created a simple 'Reset Button' which resets the form to blank, when I updated the...

Good morning all, I have a bit of a tricky situation and trying to come up with something creative. Essentially, what I want it to to is something like... Set Variable to A1 Run Loop Loop Counter = 1 Reset variable to A1, offset down 1 Run Loop Loop Counter = 2 Reset variable to A1, offset...

Good evening. I have a challenging problem I was hoping to get help with. I have reviewed other posts and found a solution that allows for clearing a range of cells based on a change, but can't find a way to clear different ranges based on different cells changing. I have dependent drop-downs...

Hi all, I have some code that will create a counter and add 1 each time the criteria is fulfilled. This is inside a loop and I have found that the counters will reset outside of this loop. Is there a way to make the counters the same value throughout the code? All help is much appreciated.

Hi. This is such a simple question that I just can't find an answer for that works. Very simply, when a certain cell is the row is filled in, the next cell populated with the Now() function. What I'm trying to do is just then select the active row from the cell that's been filled in with the...

Hi There, Im tying to have a live timer on my Excel sheet count in seconds between the time of 0730 and 1630. Then reset at 0730 the next and start counting the seconds again. I see many posts on how to do it with a start, stop button but cannot figure out a way o make it start stop and reset...

On a form I developed, these cells are formatted with a border, color and a drop-down list. I created a RESET BUTTON to clear these cells, but when you press the reset button it also clears the border, color, and the drop-down list. not just the value in the cell. What code can I use to JUST to...