pressing

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

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

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.

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

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

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

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'...

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

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

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

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

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

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!

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