press

I have a user form that has 12 Bottons on it 8, 10, 12, 14, 16 ,18, 20, 22, 24, 26, 28, 30. These number represent how many players or teams that are going to play a game. I want to add to each button a workbook that has all the imformation needed. So when I press button 8 the workbook that is...

Hello all, I've got some code that writes a formula in one cell, drags it accross and then down to populate a table. The trouble is that the enire table shows zero's. If I higlight the formula then it gives me the correct result. If I press F9, Ctrl Alt F9 etc. then that also doesn't work...

It's very useful to be able to press CTRL+[ in order to navigate to the first precedent/reference in a formula. (And then to press F5 to jump back to the formula.) However, what if a formula has multiple precendents/references, including some or all that appear on a different worksheet? It...

I am trying to remember how to use the conditional formatting function to account for press size vs hourly revenue. For example, if the company is running a 300-400 ton press, it should have a net revenue of at least $50 (hourly). I was wondering if there was a way to just input the press size...

Hello all, I am after some help. I have a database showing a rota, when I highlight cells I want a few buttons to press (On the sheet) so the cells I have highlighted go that colour.

Hello everyone For my worksheet i have this one table where i need to fill in either W or L. but i dont want to either use Shift the whole time or press capslock. I want it so i just type w and it will go to W and same with l going to L. Is this possible and if yes how is this possible? Thanks...

I am puzzled by this issue. I have two cells that have the same exact value. However, when I take the difference between the result is not zero. instead, it's 6 -- see below. The culprit is cell B3. The result changes (..to zero, as it should be) when I click on cell B3 and press enter. I have...

I have in my worksheet Lots of Formulae's and the funkction ill need is this function. when i Click on cell G7 then a Mgsboks should Show up an then show result Value from Cell D6 on first line and Value for cell D7 on second line now the worst part of it all is Instead of "Yes , No ...

I have the following code through which I am passing the address of the selected cell to WkRNG variable. Now, when I click a cell and press okay all goes fine. But, if I press ESC (without any input), I get the runtime 424 error. Dim WkSht As Worksheet, WkRNG As Range, rCell As Range...

I am trying to make a text box on my form that grows with the text. The spreadsheet needs to be locked so users can't edit it. I have tried making a text box using insert, then text box and this option works with everything except that I need the ability to press enter for a new line but it...

Dears, Help me in making one Button which I press enter the time in B10 and Press again it will enter in C10 with time difference in D10. And when I press again it will enter time in B11 and if I press again it will enter in C11 and time difference automatically in D11 and keep on going if I...

I am trying to search a word in a textbox, it shows in a listbox what I am looking for, the texbox1 code works well, the issue is the second code "selec", when I select the correct one, it does not do anything. I would like to select the word in the listbox, press enter and have it populatedin...

Hello everyone, I have a table that the first column is the column of a subscription number and all other columns are currently empty, I have defined that if I double click on one subscriber number, a form will open Then fill in all the data of the same subscription number (eg first name...

Hi, Is it possible to press a toggle button to activate a send key button then press that button (i.e. directional buttons - Up Key, Down Key, Left Key, Right Key which will have a macro assigned to each) but be able to repeat the key button press as many times as desired until the toggle button...

I want to use a command button to enter a number in a cell, on the second press it goes into the adjacent cell and third press the next adjacent cell and so on. I have tried using GoTo and GoSub if the cell is not blank but it only works for the first two number then stops. Thanks

Hi friend, how to hide entire row when press F4 (copy last format)..... and of course move to next cell if i am on A1 Press F4 hide wntire Row and move to A2. thanks.

hi all, how to join to next cell(row) i am on A1 if i press F4 (this copy the lastformat) my question is: if i press F4 how to go to A2, if again press F4 join to A3 and so on. how to configure Excel? thanks....

hi, I have a testbox1 in excel where after typing data in the text box i want to be able if required to press enter and start a new line in the textbox1, i am using the code below but i get an error please can you help me? thank you in advance. Private Sub TextBox1_Change() If KeyCode =...

Hello, Everyone. In my Test.xlsm Excel workbook. thisworkbook code is : sub workbook_open()Application.OnKey "{ESC}", "a" end sub the module code is : sub a()thisworkbook.close savechanges:=fasle end sub sub b()for i=1 to 1048576 sheet1.cells(i,1)=i doevents next end sub Now, here is my...

I have Excel Sht. Has Ribbon 6 Togglebuttons I need when Press ="True" One of then the other get opposite Press="False" Thx