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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...