pressing

  1. F

    Pressing space bar to navigate tabs

    Is this even possible vba code :- pressing space bar to navigate sheet tabs? Selects and displays next sheet each press
  2. A

    Scorer sheets

    Hi all newbie here and not the best with excel or vba :eeek: i am doing a darts scorer with a few macro button(180,140,100) and vlookup (3 dart, 2 dart finishing) which seem to work great :biggrin: so here goes 1, when 501(k21 or m21 reaches 0 it adds +1 value to i5 or o5 1st one to zero wins...
  3. P

    Copy sheet with popup message asking to name the new copied sheet

    Hi, I have a master sheet I want to be able to copy by pressing a button then getting a popup asking what name I the user wants to name the sheet and then use that to name the sheet. Thanks.
  4. N

    Pressing Enter Key in Textbox1. The row height increases of the worksheet cell

    When pressing Enter Key in Textbox1. The row height increases of the cell. How can this be prevented ? Textbox1.multiline = True Private Sub Textbox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) If KeyAscii = 13 Then 'The ENTER key. SendKeys "{tab}" 'Set the focus to the...
  5. Trevor3007

    change tabname from cell ref

    good evening, I use the following code:- Sub MyRename() Sheets(2).Name = Sheets(2).Range("d1") & "-Codes" End Sub which does work, but I want it run as soon as D1 is changed without pressing f9 or running macro. could some cool coder please sort? KR Trevor3007
  6. L

    controlling cursor movement in excel form

    Hi I created a form to enter first and last name (please see the pic in the link below). I have 2 questions: 1- I click on the first text box and enter the first name then pressing Enter will move the cursor to next box then I enter the last name. Then I press Enter then the cursor will go to...
  7. A

    SUMIF formula question

    It's been a while since I've used excel and I'm struggling with a basic formula. Can you help. Column C 9:22 has Y or N Column F 9:22 has numbers I want to count IF there is a Y in column C I tried <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'...
  8. S

    Move to next row when text reaches end of a cell without pressing enter

    Hi all, I would like to know if it's possible to move the cursor to the next row down when the text reaches the end of a cell without pressingenter. Similar to typing in a Word document where the text automatically goes to the next line, I would like to do this in a spreadsheet. I'm aware...
  9. B

    Clear data by clicking command button

    i have data for A2:AD150 i want to clear all the data with macro by pressing command button
  10. V

    Run-Time error '9' Subscript out of range only when I launch excel

    Hey, So I've tried searching everywhere for a solution to this and can't manage to find anything. I work at a medium sized company and one of our end users gets this error when he launches excel (doesn't matter which workbook he tried to open), the "continue" and "debug" icons are greyed out...
  11. A

    Assigning a specific key press to force calculate now

    I have been sent an Excel file that generates random maths questions. I understand how this is happening and how it has been set up ... BUT It has a message that says "press delete for a new question" So pressing delete recalculates all the formulae over four worksheets I know I can do this by...
  12. P

    Active X and Form Controls all seem to resize themselves on pressing

    I've been having this problem for years, that on pressing, my Form Controls and Active X controls (when used on a sheet, not in a UserForm) resize themselves, to the point that after a few presses, the size of the control is far larger than originally set, the font of the text increases as well...
  13. S

    [VBA] Missing F1 context sensitive Help File

    I have recently upgraded my Excel from version 2010 to 2013. However, the VBA help file seems go online by pressing F1. How to turn it back to a local chm file? Thanks a lot!
  14. B

    Application.OnKey "*x" and "*v" not working on Excel 2016 for Mac

    Hi I have a workbook that I have used for several years that successfully used the following code: Application.OnKey "*x", "CutValues" 'Intercept pressing of CMD+X keys. Application.OnKey "*v", "PasteValues" 'Intercept pressing of CMD+V keys. I have updated to the atrocious Excel 2016 for Mac...

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