reset

  1. reasem

    Want conditional formatting to reset after column filters are used

    Using the formula=MOD(ROW(),2)=1 to have every other row have color to make it easier to use a large spreadsheet I have. When I change the column filters the rows are no longer colored every other row obviously. Can I alter the formula at all to have it reset when filters are added? somehow use...
  2. D

    Reset Button for Drop Down Lists

    I have a workbook with multiple drop down lists. Unfortunately, all the drop downs are not using data validation. We need to have the list "reset" to the first item of each list. Is there a way to do this with just one Reset Button? Thank you
  3. M

    Why do I get error msg "Application-defined or object-defined error" when I Reset in VBA?

    Shouldn't VBA end at a "Reset" and not give an error message. And once I click "Ok" on the error message, I can re-execute the macro with no restrictions. Thanks for your help.
  4. S

    Group sum in each row according to some condition set in columns

    I have a data set of roadway and roadway segments vehicle count calculations. Data set contains: Road_ID= ID of each road Seg_num= Index of each segment in each Road_ID V1= Vehicle counts of type 1 in each Seg_num V2= Vehicle counts of type 2 in each Seg_num V3= Vehicle counts of type 3 in each...
  5. A

    Reset Excel Usedrange not working

    Hey guys, i have been trying to reset my excel range after using clear content but everytime i use it the range stays the same. anyone have an idea how to force the range to get back to "Used range" after " clearing Content " i have used CTRL + END, yet all cells are blank and nothing...
  6. S

    Upon Saving Workbook, Reset Filters in Shared Workbook

    I have the below code which will automatically reset filters when saved. However, I need this to operate in a Shared Workbook. How can I get the filters to reset when the workbook is saved, in a shared workbook please? Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As...
  7. W

    Send Email choice

    I am using a macro to send emails. But sometimes I want to see the results first. I can manually reset the options to do so here by changing the remark. ' .send '<-- Send out this email .display'<-- Display instead for the debugging only How can I get a prompt like this one to reset...
  8. N

    Running Total reset by negative value

    I am trying to setup a spreadsheet to track a number of values. I only need to create a running total when the total of 2 columns becomes a positive value and then track it back down to when it moves back to a negative. The data looks like this: <tbody> Value A Value B A + B Required Result...
  9. J

    VB Help

    Hi all, I have created 2 tabs Data and Form, Data Entry Form. With Name, Date, Item No, Outcome (dropdown) and Comment. Along with Save and Reset Buttons. Could someone please help with VB for me. Thanks JJSB
  10. D

    Count Consecutive Dates

    So I have a list of products that may show up on a report for consecutive dates. I'd like to count the current consecutive Workdays (Monday -Friday) the product has been on the list and reset the counter once it disappears for 1 day. Thank you in advance. Dean <colgroup><col style="width...
  11. S

    Reset Button to reset values to default in Drop List (created in Form Control)

    Hi everybody, I got a worksheet in Microsoft excel 365 that contain , let's say 2 drop list. Those drop list were created using developer tab - insert List Box (Form Control). Now, I need to create a "RESET FORM" button that once is clicked, reset the fields of those 2 drop list to first...
  12. C

    Command Button To Reset Values to 0.00

    I am trying to figure out a code to reset about 10 columns of data back to 0.00 without wiping out the formulas contained in a few of the cells. Would I be better off just making a command to set specific values for each cell and copying in the formula there? Thanks in advance.
  13. N

    Delete empty rows/columns and reset last cell

    Using VBA how do I delete all empty rows and columns and reset last cell? Column A can be used to determine the last row, but the last column will always be different.
  14. W

    Setting default value or clearing cells without VBA/macros

    Hello! I have been fighting and trying to find a way to set multiple cells to 0 value without VBA/macros but no luck yet. Reason why it needs to be done without VBA/macros is because worksheet will be used with mobile or tablet so excel version on those don't support for VBA :mad:. Worksheet...
  15. R

    using a macro to change the date of a Datepicker

    I have a worksheet that when a user completes they click on a button and the data is copied, pasted, and all the fields reset to blank except the DatePicker is there something I can do to call the DatePicker to reset itself back to 1/1/2019? I've been looking all over and I have found examples...
  16. D

    How to count Option button clicks on same userform?

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

    reset button with combox

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

    Multiple Reset Buttons

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

    Excluding a slicer from being reset

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

    Reset count for one column while checking another to trigger reset

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

Some videos you may like

This Week's Hot Topics

Top