cursor

I am looking for two very similar tools. I believe I would only need this to work in Column A. The first tool I am looking for is a macro that when activated will navigate the selection cursor to the next cell below that contains bold text. If you then activate this tool again, it will do the...

Hi Experts, I have a query concerning the production of a Data Validation list. I want the list to consist of 2 dates. The date which appears in the current cell above the cursor and the date 1 day after that which appears in the current cell above the cursor. Is this possible? Regards Graham

Hello, I have a basic change event macro here: Private Sub Worksheet_Change(ByVal Target As Range) If Selection.Count = 1 Then If Not Intersect(Target, Me.Range("B3:B300")) Is Nothing Then AutoFill End If End Sub The problem is that I want to be able to refer back to the cell that was...

Hi, I have a table that I need to add new records too. I would like a button named 'New Record' and when this button is pressed, the cursor (cell highlight) will go to the next row in the table, in column C in this case. Is this possible? Thanks,

Moderators, this forum's GUI has become extremely unreliable. By that, I mean: shortly after an article index page is displayed, I cannot reposition the cursor or select an article. (I am using IE 11 on Win7.) I believe the delay is caused by the time that it takes for the ad at the top of...

Say I select columns A through G all the way down, then I want my cursor and active cell to be in D1. How can I keep my range selected but get over to active cell D1? Thanks.

Hello, I have a userform with a textbox1 on it. and when the userform launches I would like to have the cursor already in it. This textbox is in the number 1 position on the tab order, and I have set the focus on it when the form launches but I still have to click inside the textbox to get...

Hi all, Looking for vba that restrict mouse movement to specific cells only? planning on jumping the cursor after A3 and positioned in C1 then back to A1 actually input cells are A1:A3. A2 to A3 cursor move by pressing Enter. i have tried the name range. looking for vba. thanks

HELLO I have created a userform everything work fine but I have issues with tab function for example when I enter value in textbox1 and press tab button the cursor should go to combobox1 then combobox2 then textbox 2 then textbox 3 and 4 respectively but in my case the cursor is not going to...

Hi all, Inspired by a question asked by a forum member, I wrote this code which should allow the user to draw freely (like a pencil using the cursor) on an userform The code also allows to copy the drawn picture to a newly created worksheet shape as well as to save the drawing to disk if...

Hi, guys! I have a bunch of VBA codes to reveal rows depending on the answers of a dropdown in certain cells. I.E. - If F101 has "Y" or "y", row 102 is revealed, else it stays hidden. My question is this: some people in my dpt don't use the dropdowns and instead would rather type in the...

I've just noticed this, which is a nuisance. It started a few weeks ago after I had my laptop re-imaged (everything re-installed). On a pivot table, if the active cell is within the table (data or labels), and the Field List is displayed, the cursor will flicker, anywhere it goes within the...

Hi All, I noticed that upon opening an excel file on my desktop, the excel cursor that's always an arrow has changed to a solid white cross (think of a + with a solid white filling) and now I'm unable to click on any dropdowns on my sheet. I am able to type in formulae but without the...

I have a survey with a significant amount of open ended questions. It order to code the survey I need to split each section of each open ended response into one cell. For example, the single cell: "Service was slow and I hated the food" would become two cells, "Service was slow" & "and I...

Hi all. Just had Word 2013 installed at work, and the cursor behaviour is driving me mad. When I press space having just finished a word, the cursor stays put, firmly attached to the end of the word I've just typed. So, If I type the word 'cucumber' and hit space, the cursor stays here...

Newby here. Please be gentle! When I run my excel macro and keep the cursor in the workbook that the macro is running in, the macro is able to set the cursor position to where I need it. I use: Workbooks("TwsDdeNick_prod.xlsm").Worksheets("BasicOrders").Range("A10").Activate Now, when I...

Hi Friends, I try to copy first 60 words from Excel Column A1 to B1. I use this formula =left(a1,1). When I hit F2 to rename, or double click, the cursor goes at the end of the column's content. My big issue is that after i drag this formula =left(a1,1), I want to see first 60 words not last...

I have a spreadsheet that was once in Excel, then printed and faxed, then scanned into an Adobe pdf image, from which the text was restored with optical character recognition, then copied (using Adobe's "copy as table", not just "copy") and dumped back into Excel. "Copy as table" did not result...

Hi, I'm looking for a quick macro that moves the cursor to the next cell in the current column that does not match the current cell's value. The following code works but is VERY inefficient. Sub MoveDown()Application.ScreenUpdating = False Do ActiveCell.Offset(1, 0).Select Loop...

Hi everyone, I am trying to run a macro in Excel 2010 to extract data from WRQ Reflections. While I have a basic idea of how Reflections works, I cannot find the cursor position (row and column) to use as a parameter for the .WaitForEvent function - syntax .WaitForEvent (EventType as Long...