I believe this is a little basic for this forum; but, I haven't been able to find a good answer just searching the web.
I have a spreadsheet that I am entering single digit numbers in each cell. I would like the cursor to automatically jump to the next cell to the right after the number is entered (without having to hit the right arrow key).
I am making a template for my company to automatically calculate the amount of sheet metal needed for a specific job. The spreadsheet could get very long depending on how much duct is needed. Is there any way I can automatically insert rows to the end of the sheet by pressing enter after filling the last row with data, which would then move the totals down. Also, the formatting of the rows I wish to add need to be copies of the ones above.
View 3 Replies View RelatedIs it possible to change the behaviour of the return button within a textbox? What I would like is, once the return button is pressed, it starts a new line in the textbox rather than it moving to the next textbox within the form.
View 3 Replies View RelatedI have a sheet with part protection and have 4 columns that I want to enter data. Need advice on macro -columns cdef. When data in column c entered, go right two columns, enter data in column e, go right, enter data in column f, and go down, and back, to column c. That is on the next row down ready to enter next set of data.
View 2 Replies View RelatedI've exhausted my search engine skills and I'm about 99.9% sure Excel is incapable. This message board has been great over the years of figuring out even the trickiest of problems, but is there any functionality in 2003 or the slight possibility that after a user inputs a number in a cell (no tab, no enter) that it will move to the next cell.
After reading about this, most people say it is not possible even with VBA or Macro, and I certainly believe it, but the whiny, and horrible department that I work for are curious if this is possible. So, is it? If this is the wrong area for this questions, I apologize, I was considering putting this in the Macro/VBA area, but I gave up in deciding where to post this.
I have set the default in Excel to move across to the next cell after I press Enter. This is fine for most workbooks but I have a particular workbook in which it would be preferable (save keystrokes) for the cursor to move down one cell. Is it possible to have one action as the default but another for a particular workbook?
View 7 Replies View RelatedI need to change the way Exel move the focus when I press return in a cell. For example when I am in column 1 and press return, I want the focus to move to column 4. If I am on column 5 I need to go on the first column of the next line, etc ...
I think I am suppose to use ActiveCell.Offset(1,0), and ActiveCell.Offset(-4,1) for my 2 examples. But my question is what is the VBA code for: "do that when I press enter and I am in this column"?
I have this macro that automatically inserts the date in column B when data is entered in column D. What I would like to is when I press enter in a cell in column D then the selection cell will move to column E and then when I enter again in column E then move to column D again on the next row. IE. if I'm in D12 and press enter then move to E12 and then move to D13 and so on.
View 4 Replies View RelatedImagine you have only one column - column A. In column A you have 500,000 + rows with text like the following:
!magnus
snooze'
sleepy/
act noun
act verb
Today&tomorrow
*bialgebras
/dev/ null
dev
ull
1970;
Dwight Schrute
and your goal is to figure out a way to simultaneously transform the above rows into:
snooze
sleepy
act
act
Todaytomorrow
bialgebras
devnull
devnull
1970
DwightSchrute
I know I can use Filter and filter out characters like &'!/; but that takes too long because I have a lot of lists to go through with thousands of entries. There must be a macro that will close spaces between words when only one space exists, but eliminate every word if 2 or more spaces exist between words - as well as eliminate unwanted characters like the ones I described above. I know I could use substitute and eliminate the spaces between words =substitute(a1," ","") but then I'd have to filter each and every instance of unwanted character.
This vlookup has been in this workbook for years. All of a sudden any of the cells that have formulas won't work without placing the cursor after the formula in the bar and hitting enter.
It is keeping a marco from running correctly.
Can I make the cursor use only 2 columns? In other words, I know that when I scan barcode data into A1, I have the cursor automatically move to B1. BUT, once I've scanned data into B1, how do I make the cursor automatically move to A2?
View 2 Replies View Relatedhow to change cursor colour in excel 2013.
using Control PanelEase of AccessEase of Access CenterMake the mouse easier to use does not work as it will change mouse instead of cursor colour in excel 2013. e.g. original cursor colour in excel 2013 is green, change to any colours.
I'm trying to get the cursor to turn to the hand (with the index finger pointing) when the user rolls over a label.
View 4 Replies View RelatedI would like to change the mouse cursor when the pointer passes over (without clicking) some cells which have double-click-event script attached.
I know how to change the cursor with a custom one. The pb is for me to identifie that the pointer is over the cell so as to launch the cursor change macro (and reverse when going over another cell).
Excel does that, for ex, with commented cells but can VBA do it also?
I am working with a VBA userform and several textbox's, setting SetFocus and or TabIndex doesn't leave the box ready to accept input and there is no cursor shown to indicate it is ready to accept input.
View 2 Replies View RelatedI am trying to do a formula in one cell(in which i will hide) and have the answer display in another cell. but i would also like this to effect another cell.
Example:
Total footage in cell d7: 270,000
Complete footage in cell d10: (would like this cell to be an input cell but effected by % cell)
%complete in cell d11would like this cell to be an input cell but effected by complete footage cell)
So if i change the value of d10 to say 100,000 then d11 would automatically show 37% and vice versa if i input 37% into d11 i would like d10 to automatically display 100,000. (note these values are variables and will change).
I am a personal loans officer and have created a worksheet to input a range of information about an application. The information is personal details and details about the loan. The data I input runs down Column D [with line breaks to seperate the answers into categories] with the question beside it in Column C.
I do this for every new application as I use it for reporting on my loans as well as mail merge to produce documents for the loan.
Currently I am doing one per loan but would like to have a button at the bottom of the page that once clicked, it will push the data onto another worksheet so that all my loans for that month are on the one spreadsheet. The data will be pushed onto a row, not a column, but it will also need to find the next available row to put the data on.
Once the button is clicked, the first worksheet will clear ready for the next loan to input and the data will transfer to the 2nd spreadsheet. And, if possible, on the first sheet will be a drop down list of all the current loans so I can recall any application details to the first sheet if needed to update details. So if the 'loan number inputed' already exists, it wont create a new line on the 2nd spreadsheet, but will know just to update the fields.
I have 4 lists and I have some code that let's me select an item in 1 list and get its corresponding value in the second list. I have managed to convert my lists to combobox on doudle click by using some code and now I want to be able to hit enter and the value that I searched for in the first combobox gets its corresponding value in the second combobox.
View 1 Replies View RelatedMy understanding of Excel is that the calculations are performed in Column A first and then down through the rows in Column A. After all the calculations are finished in A, the calculation moves over to Column B and down the rows in B. Is this true?
I know that Excel is a little more complicated than that especially when it creates a queue for calculations, etc. However, assuming there's no calculation list/queue, would the above be correct?
I have a user entering text into a textbox on my userform. The textbox is linked to a textbox change event. Unfortunately, the event is triggered as soon as the user enters the first character of their entry. I'm thinking that the textbox change event isn't the most appropriate for this scenario. What would I need to do to trigger the code (of the change event) with hitting ENTER when finished?
View 9 Replies View RelatedI have a list of wind directions and I want to get the average. Obviously, there is an issue since the average of a northwest (330) and northeast (030) wind is 360, not 180. I've got several formulas in the attached spreadsheet, but none seem to give the correct results.
View 3 Replies View RelatedI'm trying to do is take the difference of two wind directions but need the actual difference not the true mathematical difference. For example:
Wind direction 350 was forecasted
Wind direction 020 was observed
The difference is 030 degrees off not 330 degrees.
How do I do a formula to state the true difference not numeric?
I was figuring these conditions:
- if the number is above 180 & below 360 just subtract 180
- if the number is below 180 & above 0 just add 180
Using w/ example:
350-180=170
020+180=200
170-200=-030 (then take ABS to get 030)
I'm a weather professional and doing tons of metrics regarding weather parameters.
is there a way of changing the text direction for an ActiveX textbox? I need it to show the text in some of the boxes vertically but in other boxes horizontal.
View 7 Replies View RelatedMove after return direction Xltoright In Specified Range.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = ThisWorkbook.Worksheets("mastersheet").Range("trgadd") Then
Application.MoveAfterReturnDirection = xlToRight
Else
Application.MoveAfterReturnDirection = xlDown
End If
When placing a control on a worksheet, the text in the label,option box etc controls is vertical and I can't find a way of changing the direction to left to right. It doesn't happen on all workbooks. I can put the control on a "normal" workbook and then copy it to the "abnormal" workbook but I would like to know why/how I can change the direction of the text.
Under Tools/Options/International the text direction states left to right
Have attached a small 2007 excel spreadsheet to help explain my needs. I would like to know if there is a function that when data is entered into column A it is then transfered to column B, B data transfers to C, C to D, D to E etc. with the K data falling off (10 Columns). I need this process to happen even when the new A input data is of the same value as the last A input data.
View 4 Replies View RelatedI really know nothing about vba so here goes. I would like to enter data in a row with 4 cells of info. then hit enter and return to the first cell and move the row down. all four cells must have data entered. and all four must move down. i tried some code as below i found and i modified but it did not work as expected. this moved the row down when returning the cursor to A2. It also should not copy the data style of the top row.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
Application.EnableEvents = False
[Code].....
This formula must be confirmed with CTRL+SHIFT+ENTER not just ENTER. You will see { } brackets appear.
View 3 Replies View RelatedI'm trying to create a wind rose using data from a logger. Have wasted a lot of time so far.
Formula that could put this data into some kind of wind rose?
The main information I'm interested in is the length of time the wind blows in different directions.
I'm talking about the little black box that appears anytime you put the mouse on a cell, or drag the mouse around a group of cells - mine doesn't show up. I can still edit the cell, but I have to guess about which cell I am on.
how to make my dear cursor reappear?