Enter Key Behavior
Jul 12, 2007Some option must've changed recently in my excel spreadsheets by accident and now when I hit the enter key it doesn't drop down to cell in the next row, it just stays there.
View 5 Replies
ADVERTISEMENT
TextFrame.Characters Behavior
May 31, 2009I use the command
ActiveSheet.Shapes("ZoneTexte " & R_Box).TextFrame.Characters(Start:=1, Length:=10).Font.Size = 10
To modify the Font.Size the 10 first characters in my textbox.
Work fine the first time. Problem occured when the same macro is called for the second time in the same textbox.
Problem: I got 20 of the first characters font.size modified instead of the first 10. Calling it a third time, i will have thirty characters. The start :=1 seems to be modified.
Strange and i have problem to explain it using my FranGlish language writing
Change Behavior Of A Built-In Toolbar Button
May 8, 2008I am trying to assign a macro to the Print button on the Standard Toolbar. Basically I want that button to print the number of pages I've specified in a cell, but I still want to be able to use the 'File/Print...' option if I need to.
I did try to solve this issue in an earlier post, but this exact problem remained unsolved. For more information
http://www.excelforum.com/showthread...89#post1916589
Override Cell Drag & Drop Behavior
Oct 13, 2007For example. Dragging c7 to e5.
My range before dragging and dropping...
After the drop.
What do you think? I think it can be done but do not want to waste time going about it the wrong way. Please give me any ideas on how you would approach this problem.
Some information to start with. The modal dialog that pops up can be dealt with.
This one.
I can determine if I want to insert down or up. I am not concerned with shifting left or right at this point.
I can also determine the original address and destination address of the drag and drop operation by using the change event.
The ranges being dragged will be limited to a single cell.
Weird File Open/Save As Behavior
Dec 12, 2005A client of ours has one particular file that has some very strange behavior as described below. This only occurs with the one particular file and the behavior is consistent across different PC's in both their office and ours. All other Excel files in both offices work fine. Here's what happens:
- you can use Windows Explorer to copy the file between drives without
a problem (as expected)
- if you open the file in Excel on one drive then save it back to that
same drive with either the same file name or a different file name, the
file works fine (as expected)
- if you open the file in Excel on one drive then do a "Save As" to
save it to a *different* drive with either the same file name or a
different file name (in default .xls format), the new file causes
errors in Excel every time you open it as per below (weird!)
- even if you do a "Save As" and choose a different format eg Excel
97-2003 or Excel 95, the error behavior is consistent (weird!).............
Enter 4 Columns Of Data In Row Then Shift After Hitting Enter?
Jun 1, 2014I 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].....
Formula Must Be Confirmed With CTRL+SHIFT+ENTER Not Just ENTER
Aug 15, 2008This formula must be confirmed with CTRL+SHIFT+ENTER not just ENTER. You will see { } brackets appear.
View 3 Replies View RelatedHow Do I Enter 005
Feb 17, 2010I am writing a macro and using the filepath, it will change from 001 to 002 etc. I would use a ' but when it gets to 010 it goes wrong! is there a formula I can put in a cell that when typing 5 it results in 005?
View 9 Replies View RelatedCan't Enter Any Data
Feb 23, 2007I've been using Excel for years and had very few issues. However, I recently went into a spreadsheet to update it and was unable to select and enter data into an individual cell. When I click on a cell and try to enter #s nothing happens (my num lock is on). Then when I try to click into another cell it just highlights that cell, along with any other that I move my cursor over. Once I click on one cell I can't stop the highlighting from happening. I can't even click on anything in the toolbar.
View 14 Replies View RelatedAlt & Enter When Using Text
Nov 28, 2008I have manually set all row heights to 12.75 to make sure they are the same. In these rows I have a comments box and when the end of the cell is reached I use alt&enter to continue writing underneath. Seems the comments cell has stopped re-sizing.
View 2 Replies View RelatedEnter Value And Skip To That Row
Jul 15, 2013I have two sheets open. On the first sheet i have a drop down list of dates from which I select. That list of dates is on another sheet. I want to be able to select a date from the drop down list, then when I go to the second sheet, excel skips down to the row that contains that date. I can also make it values if it is easier.
View 2 Replies View RelatedText Box Run After Enter
Sep 29, 2009how can i define in code, that my code will start after pressing "enter"?
i have textbox, i write something and i have a code. I want only launch my code after pressing enter.
Using Enter In Userform?
May 30, 2012I have this series of userform modules that error check the user's input of a date value.
Code:
Private Sub txtDate_Enter()
txtdate.SelStart = 0
txtdate.SelLength = Len(txtdate.Value)
[Code]....
Everything works fine, but I'm looking to improve it's efficiency. Most people will by habit press [ENTER] after inputting the date in the textbox txtdate control. As it is now, for the code to execute after the value is entered is to push the {SUBMIT} button.
What would I need to do to allow hitting [ENTER] to do the same as clicking submit?
Userform Tab Using Enter Key?
Mar 7, 2014I have a userform made with excel. I need to tab to the next field (in the tab order) when I press enter instead of having to press the tab key. Is there an easy way to do this. Im not that savvy with VBA.
View 1 Replies View RelatedENTER = Activate?
Apr 8, 2007In the following code, I have a find sub... when the user enters a date and hits the "Enter" key, is there a way to bypass the "Ok" key?
Private Sub cmdFind_Click()
Dim ws As Worksheet, myDate
Dim rFoundDate As Range
'check for valid distribution date (between October 1, 2006 thru December 31, 2014)
myDate = txtFindMyDate
With myDate
If DateValue(txtFindMyDate) < DateValue("10/1/2006") Or DateValue(txtFindMyDate) > DateValue("12/11/2014") Then
MsgBox "Please enter a date between October 2006 and December 2014"
.SetFocus
Exit Sub
End If
End With
Cells.Find(What:=txtFindMyDate, After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
ActiveCell.Select
Unload Me
End Sub
Cell = Then Enter
Aug 3, 2006Is there a way of a message being displayed if a cell has a specific value.
e.g. if cell A1 = 2 then a message is displayed to say 1 more and action will be taken.
Vba To Check For And Enter Value
Jan 26, 2007In vb would it be possible to make a macro to check if a cell has writing in and if it does enter a value underneath.
View 2 Replies View RelatedEnter Vs Return
May 18, 2007Im using an old IBM tb3270 mainframe as described in this historic post:
[url]
ive tried {ENTER}, ~, char(13), etc etc but every one of them is just going onto a new line! Anyone any ideas how to get it to send the enter fuction, from the keypad?
Bind The Enter Key
May 22, 2007I am trying to use the enter key to populate a range with a userform's textbox data.
View 7 Replies View RelatedVBA - Prompt To Enter Data
Jan 15, 2007After recording a macro that goes to last figure in data, how do I edit this to prompt for a new data value and enter it into 1st empty cell at end of data?
View 8 Replies View RelatedEnter Date Without Day In Cell
Jul 31, 2014I have to enter a ton of dates in cells that don't need to include the day. And so was hoping if there was a way to enter a date into a cell without having to enter the day.
In essence, it seems like I have to type in the date as month/day/year and excel will figure it out from there. I would like to be able to just type month/year without bothering with the day, such as 9/14. And then excel recognizes this as a date.
Excel has to be able to recognize it as a date because these dates are expiration dates. And I would like to conditional format these dates so that when the expiration date has past the cell turns yellow.
Can't Enter Text In Cell
Aug 2, 2014When I click on a cell to enter text, a new little text window pops up inside the cell and doesn't allow me to enter text. No matter where I click in the cell another little text window appears. I also can't delete the text in the cell because the little text window pops up again and again.
Here's a pic of it: [URL]....
#NUM! Error When I Enter A Number
Jun 18, 2009Why is it that I recieve a #NUM! error when I enter a number (monthly payment) of 233 or less?
The formular I use is: =NPER(C79/12,-E79,D79)
Error:
C79 - 7%
D79 - 40000
E79 - 233
F79 - #NUM!
This works:
C79 - 7%
D79 - 40000
E79 - 234
F79 - 1008
How To Enter A Decimal Number
Nov 30, 2013I am facing few problems with excel ever since I updated windows 8 to windows 8.1. Whenever i try to enter a decimal number in excel, say for eg. 3.4, it reformats to date- Apr03. I even changed the date and time formats for eg. short date is formatted to dd/MM/yy and long date to d MMMM yyyy. The format is set to enlgish (uk).. what should i do?
View 1 Replies View RelatedHow To Enter % Formula Into Cell
May 1, 2013I need to take a figure that appears in a cell, take off 20% vat from it and then calculate 16% off what is left, that is the figure I need in the new cell ? Show me exactly how to write that formular into the new cell?
View 3 Replies View RelatedAdd Enter To Text From Array
May 17, 2014I'm trying to add an enter space to text with the combination of a loop and an array, but I cannot find the right combination so that the final result appears as so:
ArrayItem
Desired Text
or via excel
=NamedRange&"
Desired Text"
Here is the code for the loop, trying to add the appendage to the first item after the if.
[Code] .....
On Key Enter Event Within Worksheets
Jun 26, 2007What is the method to trigger an event on a command button (placed on a worksheet - not in a form) when the return key is pressed? I.e. instead of moving to the next cell clicks the button?
View 9 Replies View RelatedEnter In Multiple Vba If Statements
May 17, 2008I have attached a copy of my monthly work schedule. Sorry if it looks too noobish but I am.
The question I have is on the schedule right now, it uses to of the same schedule, one is called request off and the other the final. The request off right now is where all changes are made, and they reflect on the final. I did it this way because I could not figure out how to make the cells autofill according to the day of the week, like if it was friday i needed it to fill in the shifts and normal days off automatically.
What I am trying to do now is eliminate the need for the second schedule, the request off one. I think I have figured out how to have the cells autofilled according to the day of the week, and also let the user enter in other stuff such as sick, vacation or whatever, and have it autofill if the cell is left blank, using vba. this is what i have so far, and it is working I was just wondering if it was possible to set it up for a range of cells instead of having to enter each one in manually.
Default Enter Key On A Multipage
May 9, 2009If i have a form with a multipage of 2 pages on it and on each of the pages i have a button and a text box, is it possible to have each of the arrangement linked to the enter key.
eg button 1 to textbox 1 when i hit enter on page 1
button 2 to textbox 2 when i hit enter on page 2
Enter Array Formula Via VBA?
May 22, 2009I have following Array formula in Cells N1:N3.
HTML =SUM(IF(O$4:O$1000="Total I/O Points",N$4:N$1000,0))
Each formula has different text in "".
There are a few macros in this workbook that delete and/or insert rows.
When that happens, the formulas listed above get modified with different references. How do I restore the formulas back to the same range reference [O$4:O$1000]?