typing

Hi there, I have a spreadsheet for user info entries. This has been working successfully but something has just come to my attention... If a user enters something into a cell and starts off with a - (minus sign) or = (equals), Excel is expecting some sort of formula to happen and causes an...

Hi Folks I can't figure this out at all. :mad: I have a table of data. They are all formula links to various other sheets. Once each row has been checked the last column in the row has the text 'complete' typed into it. I then select the row and copy/paste values to remove the formulas. It...

What would I use to enable typing to auto populate into a drop down? The cell isn't locked so you can start to type in it and we want to be able to start typing the chart field number so we don't have to scroll through the whole list. Thank you.

This is weird: I have 4 command buttons (CommandButton1 thru CommandButton4) and 1 text box (TextBox1). I get a 424 Error whenever I try to set a TextBox1 property such as TextBox1.Left I ran a short sub to grab all the shape names in the active worksheet: For Each Sh In ActiveSheet.Shapes...

separate cracks without typing example 18 20 36 = yes for 6 digits without repetition 18 20 38 = not because there is a repetition of the digit 8 there can not be in the separation of the cracks, cracks with repetition of digits including zeros...

Hello, I’m trying to figure out how to customize specific cells to add 2 decimal places when typing a number. For instance, I would like all numbers within cell range B2:B20 to add two decimal points when typing a number. E.g. – In cell B2, if I enter 1234, I want that cell to display 12.34...

Typing my question in the forum helped me find the error. Thanks for the help!

I am writing formulas that reference cells with defined names (for Example "First_Exterior_Wall_LF") and when I start typing the cell name into the formula window it drops down a little autocomplete (so I type "First_E" and the proper cell is listed right below), but I can't seem to select or...

Hi, I have a list in column A and ComboBox1 is in Userform1 When a user begins to type in the combobox I would like a list of 3 options to dropdown filtered on what they're typing. If the user continues to type and it's not in the list I would like what the user is typing to be added to the...

Is it possible to have a validated cell show the drop down list once I begin typing something into the cell, without having to click on the arrow with my mousse?

Hey guys, I can use some help please. If you can look at the attached image, I would like when I am typing in each cell I have expanded to have the text fit into that cell alone. As the attached screenshot shows the text is flowing outside of the cell into the next, how can I have the text flow...

Dear All, I'm beginner in VBA and I've been trying to solve this for 2 days... I have a problem with the continue typing in combobox with search option in userform. The thing is that when I type a letter first match is autmatically a value of combobox and I can continue typing from the end...

Anyone know a reason my cell drop down validation to a named list will still accept any typed entry? The drop down works and shows the list. Selecting one of them does populate the cell. But so does just typing whatever you want in there. That's not the way it's supposed to work. What have I...

I very much like this link: Populate userform combobox with unique values from a range It explains how to get a drop down list of unique values and that is exactly what I need but I have almost 7000 options. I want the user to be able to start typing the value and have the drop-down populate...

While typing in a cell, there are automatic vertical lines between each latter. The lines disappear when exiting the cell. This started happening recently. Please help, this is driving me nuts. Microsoft Office 2010 (I had to paste the image, sorry about the resolution)

I started by just recording a macro and typing in to the cells what I want, adding a note for the drop downs and keeping it visible, using Application.Wait to pause in between... But it's still not really what I want. The "instructions", or values, I guess, just appear in the cell and it's not...

In column M is a sequential list of column addresses that I need to add to. Is there a way to use a function so that the next column address in the sequence appears automatically rather than my having to type it in? O P ... rather than typing in "P", it would be the column value above "plus...

hello guys, would you help me to insert these formula without typing it again and again.....thank you... example:=F210&" "&F211&" "&F212&" "&F213(in cell e210) such like e214 and e217.....and etc... Excel 2007 <tbody> E F 208 STANDARD KANDUNGAN 209 210 1.4 Bertutur,berbual dan...