double

  1. S

    VBA If for selecting value error

    Good Evening, I have an ETA calculator (Time/Distance= Speed) that is giving me an error. Now the error takes me to various other bits of codes like my timestamp macro but it's all based on one part here. The Distance (DTG) below is the cause. If I input data into the "S29" cell, it works...
  2. M

    Double Click Sorting in VBA

    Hi, I have a sheet where the headers i want to sort start in row 4 and the data is below. The first column with data is column B. Depending on the sheet there are different numbers of columns and a different number of rows. I read that it is possible to sort data by double clicking on the...
  3. D

    Clicking different cells to open files

    Hi guys. I have a spread sheet with multiple options on there. Previously I had used hyperlinks to link to word documents for the shipping labels but people are clicking by mistake a making a right hash of things so I am now looking at adding VBA code where you would double click a set cell and...
  4. S

    Formula Chooser

    Hey Guys- I have this If Then piece I've put together that's supposed to choose one of two formulas for a cell, based on what the previous sheet is, and then input that formula into the cell. It does this for two different cells. Currently I have something wrong because both cells just come...
  5. R

    Source of Excel File

    Hello All, How can we know whether the excel file is opened from a batch file accessed through Command prompt Or manually by double click. Need to call different functions based upon this condition. Thanks in advance. Thanks, Rahul
  6. M

    Excel leave existing date in cell (calendar VBA)

    I am using VBA calendar to input dates in my workbook. I have added code to my worksheet to call calendar on double click of cell. So basically when I double click cell in range I get calendar form, where I pick up the date and then it is inserted in double clicked cell. The problem is if I...
  7. S

    Dbl click is taking me to WRONG cell!

    Omigosh I'm about to lose my mind. Why is Excel taking me to the fifth cell in my formula instead of the first?! All that mattes here is that I want to go to CA325 if I double click or ctrl +{ (YES, "Allow directly editing in cells" is OFF) =(CA325*0)+...
  8. R

    Protect Shapes wile allowing doubleclick+data validation lists in same cell

    I'm stuck. I can't find a way to protect my sheet while allow users to double click in a cell, use data validation list in the same cell while protecting shapes from being edited. When I set DrawingObjects:=True the shapes are protected but I can no longer double click in a cell that has a data...
  9. M

    Putting double quotes around text

    i have a formula in cell A2 with a text output. I need to add double quotes at beginning and end. however if I try to use this code i.e. a double quote inside a pair of double quotes as you would add any other text ="""&A2&""" I just get this which isn't helpful <tbody> "&A2&" </tbody>...
  10. C

    DoCmd.OpenFOrm not working on new computer

    We have been using an Access form that you can double click on the results and it opens up another form "FRM_EDIT". I have about 5 computers that use the same thing and haven't had any trouble. Recently we got two more PCs and neither of them do anything when you double click to open the next...
  11. G

    Calculating double time after 12 hours plus sundays

    Forgive me if this creates a redundant thread on this topic but I am at my wits end. I have searched all over the internet and can't find a solution to my specific excel problem. On time cards where double time is after 12 hours per mon-sat and all day sunday, how can I create a function for this?
  12. G

    Toggle text between cells

    This is my first ever post. I have a spreadsheet that has a lot of check boxes in sets of two. When printed it is hard to tell what is checked. I have redone the sheet and replaced the check boxes with empty cells. I also have a VBA code that will enter a check mark when a cell is double...
  13. O

    Double click to change cell to multiple color or back to original

    Below is a piece of code from another thread where double clicking on a cell changes the cell to red. If you double click on the cell again it changes back to its original color format. I am looking to see if there is a way to add additional colors to the choices. For Example, the first double...
  14. K

    VBA to extract full decimal from percentage in cell

    Cell A1 = 29.7% <code> Dim PROF As Double PROF = Range("A1").value Range("B1") = PROF </code> B1 = .30 I want B1 to = .297 :banghead::banghead::banghead::banghead:
  15. M

    IRR vba vs. worksheet function

    Hi, I updated a macro so that it uses the IRR within vba rather than the IRR worksheet function. To test this compared the worksheet function vs. IRR function & notice that the vba function is erroring out & the worksheet function returns a real value. Why is this...
  16. R

    Creating a Workforce Management Forecasting tool. Looking for feedback

    Hello, I'm setting up a tool that will help to forecast staffing required to handle call volumes and would like some feedback. I have shared the file through the link below. The excel sheet does contain Macros. I'll post them for review as well. Many thanks to anyone who is willing to look...
  17. serge

    Return a double digit

    I'm looking for a formula that will double the same digit. In cell L6 I have digit 4 and need in cell S6 = 44. 1 = 11 2 = 22 3 = 33 etc... Thank you. Serge.
  18. M

    overflow with double precision

    Hi, I am getting the error "overflow", when I assign a variable of type double a number >32,000. What is going on? dim guess as double guess = 73000 'no overflow error guess = 73 * 1000 'gets an overflow error I remember this error happening in the past.
  19. B

    Repeat code for rows

    Hi, I've made this code for one row, and want to repeat it for the next 200 rows or so. Any tips? Dim d As Double d = Range("H10").Value Range("H10") = d + Range("J10").Value d = Range("I10").Value Range("I10") = d + Range("K10").Value Range("J10").ClearContents Range("K10").ClearContents

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top