key

Hey everyone, I would appreciate some help on using the sheet change event with scrolling. For instance, how would I Scroll to the target cell that triggered sheet change event. One way to achieve is to use the following two lines ActiveWindow.ScrollRow = Selection.Row...

Could you help me to create the .txt file from the Excel spreadsheet. What Visual Basic code would I use? The correct format to use for the text file is: Document Number + Tab Key + Amount (with a decimal point and no dollar sign) + Enter Key. Repeat for each request I need to process. Text...

Hi all, Perhaps someone can answer this question: I have rows of data in two lists in different columns in Excel. Both lists have keys for their indices, these keys are numeric and can only be from 1 to 999,999. One list has 18 columns including the key which is in column A (so the columns from...

i am trying to extract alphanumeric data like EXAMPLE: 785abc25d so i tried so please help me i am using excel 2010 version =INDEX(ROW(INDIRECT("1:"&LEN(A36))),N(IF(1,MID(A36,ROW(INDIRECT("1:"&LEN(A36))),1)+0))) after i pressed f9 key to evaluate so it is showing...

I made a formula which consists of multiple IFERRORs with LOOKUPs and INDEX MATCHes. Basically, if th formula doesn't find the info, look it up on another workbook. The thing is... Inside the third (the last) IFERROR, the "value_if_error" part returns an information, if I press the F9 key on it...

What is Alternate method to change Focus from TextBox to another Control whose following properties are Textbox1.EnterKeyBehaviour = True Textbox1.MultiLine = True Following does not Trigger to set focus on another control Private Sub Textbox1_KeyPress(ByVal KeyAscii As...

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

I have tried to reverse engineer a vba script to produce the code below here which allows for only alphabets and the characters listed. Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) With TextBox1 Select Case KeyAscii Case Asc("a") To Asc ("z")...

Hi I'm new to using this forum and only dabble in VBA so my apologies if I make mistakes in my attempt to get the information I require. I want the Left Arrow key press to be ignored if the active cell is in column one. Without it being ignored the active cell now moves up one row and to the...

Hey all, I am wondering if it is possible for a macro to be called upon when a key state is Up. It can be done in a user Form but I would like to achieve that in a sheet without any userform. But if a value is being entered in a cell and/or the formula bar is in active mode, then bypass/avoid...

All, [Using Win10 and Office 365 Business (Excel 2016?). I don't have any other versions of Office/Excel installed.] When I'm editing a form's property, like Caption, when I use the backspace key (to delete values), there is a very noticeable lag/delay for each key stroke. If I use the Delete...

Hey all, I would like some help on creating a stopwatch that works every time a key is pressed and stops every time the same key is released. A pop up that should let the user know for how long the key was pressed for. This should work for any key. eg format for the pop up window The key...

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; color: #454545}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; color: #454545; min-height: 14.0px}</style>I am reaching out to you guys because I have no experience with VBA but I...

Hello all I am trying to add a Primary key in column "A" starting at "A13" If there is a value in column "C" then add a number in column "A" IE: "A13" would be 1 "A14" would be 2 "A15" would be 3 Below is a start but it needs to look at column "C" and so on Sub Key() Dim rng As...

Hello all I hope you can help on this please I have a workbook which is sent out to a user to update Columns "W" & "X" Columns "C" & "H" & "O" combined make up a primary key I want to save the users updated file in a folder Open up my master file and run a macro that points to the folder...

I have Excel Office 365. My question: how do I prevent scroll lock from "auto-disabling" after I save? Here's what happens: (1) I have scroll lock enabled on a spreadsheet, (2) I enter any new information on the sheet, (3) I click control + S to save my work, and (4) scroll lock automatically...

I've tried looking for Asc 13 in both KeyUp and Keypress events but it is ignored. This isn't how it should be is it? Doesn't show in the Exit event either. How an you tell if a user has pressed Enter, or instead has clicked away from the text box?

Hello - I'm trying to calculate headers for a workbook, where we have a new header by date. The headers would be named "Key Accomplishments: 11/25/18"... "Key Accomplishments: 12/09/18", etc. Right now my formula is: =LEFT($O$1,20) &" " & RIGHT(O1,10)+14 which returns: Key Accomplishments...

Shift-F2 is still the shortcut key for inserting a new note (ex comment) but I cannot find a shortcut key for insering a new comment - Alt-RC will do it but nowhere near as easy; and my brain is wired for shift-F2 . Anyone, please?

I'm working on a file that will have multiple fabs that I'll need to pull data from. The key vertical lookup will be the building name (in column A), and the key horizontal lookup (column header) will be Electric Units. I need to do an INDEX MATCH MATCH since the columns on each tab won't be...