typing

Hello folks. I want to be able to see how many characters I am typing into a cell as I type. I know there are many ways to see the length after the data is entered, but I need to see the count 'in-flight' if possible.

Hi All, I have about 15 sheets in one workbook, which are named using numbers eg. 12345, 54321, 65432....etc. I'd like to reference/link the names of all these sheets on to one main summary sheet. This is different from referencing the sheet name within that same sheet. Is there some way to...

I have a VBA code that I run on a spreadsheet at the end of which, I'd like it to activate the already-open QuickBooks program. I'm trying to shave off as much time as possible in my tasks. How can I do this? UNNECESSARY EXPLANATION: While the code is running, I activate QB and create a new...

I need to be able to quickly copy formulas on sheet1 by dragging but excel doesn't recognize the sequence e.g. CELL D56 =IF(OR(B56=""),"",IF(OR(Sheet2!E32=Sheet1!B56,Sheet2!E32=0),"OK","ERROR")) CELL D57 =IF(OR(B57=""),"",IF(OR(Sheet2!G32=Sheet1!B57,Sheet2!G32=0),"OK","ERROR")) CELL D58...

Hi , I have values across row 4 from col A to Col AA that I have to concatenate and separate by commas. I believe I saw a third party solution with a custom MConcat or something like that. Can someone advise best way to concatenate without typing out A4&","&B4 etc... Thanks

im trying to insert a table in a specific range (b10 to bb11)....when I try to add to the table by typing something in b12, the referernces are messed up...eg W12 should be referring to b12, but instead references b13. yes, i removed the header row and Excel did make a warning about formulas...

I have this code that allows the user to just type numbers in the textbox to avoid typing in the wrong format. I would like to know is this could be set up to allow for typing in a ratio. (i.e. 2:1, 10:1, etc.) so the user avoids typing in the wrong format. The number "1" should always be be...

Hi all =) I have this formula =if(a1=3,b1/c1,0)*100 Now if b1 is “0” and c1 is “0” then I get the #div error. I have tried typing “ iferror” at the start but it isnt working. Can someone help me fix this please?

I need a form Button to Move to the relative cell in Column J (relative to the row I'm typing in). So, if I'm typing in any cell in row 25 I need it to move to Cell J25 and type a text when I press the form button. I know how to get the text in. When I record a Macro, it's recording an...

i have userfor and input a few numbers. i was hoping to have the previous number displayed in the text box. Is there a way i can have a value showing in the text box but as soon as i select the text box and or start typing it disappears? Just like if you google search for mr excel and in the...

Hi clever folks, Just a very quick query, is it possible to click a cell rather than typing in the cell ref? Rather than typing in: Range ("A1") I would like to type Range(" and then click the cell in excel to fill in the range details. I know this is lazy but I have a lot of very small...

I'm adding UDF macros into Personal but they neither show up on worksheets when I start typing =nameoftheUDF nor in the QAT under macros. What's going on? Thanks **UPDATE*** looks like competing "Personal" files

Hello, I have a userform with over 100 text boxes... Is there any way to change function of below code? Like from textbox1 to textbox100 all will be same format instead of typing one by one... TextBox1.Text = Format(TextBox1.Text, "###,##")

Hi All, I have a sheet that is used for reconciling information from 2 sources. This includes a column that I only want filled with a pasted value, as one user insists on typing the amount in manually and invariably ends up making some errors. Is there a way I can lock these cells so they...

Good day all. Hoping there's a good samaritan out there that can help me for a minute. The reason I joined this forum today was to research whether anyone else was having delayed responses when using active x comboboxes in 2013. What I have is very basic, the combobox is linked to a dynamic...

Hi All, I always find myself typing the following for getting the Lastrow when required ThisWorkbook.Sheets("xxx").Cells(Rows.Count, x).End(xlUp).Row However, I have been learning to create functions recently, and I have been messing around and created the below Function GetLastRow(ws As...

Hi All, So I just watched this video, and it did exactly what I needed it to do! However, I'd like it to do it automatically... is there a way to make this data consolidate when I'm done typing, instead of clicking through the Data > Consolidate THANK YOU!

My client's accounting system has an Excel link to upload transactions using OLE. Generally works well, but I have one really annoying issue!! The concept is that a cell (eg B1) has a custom formula in it which contains the entries to be transferred across. Typing "Yes" in upload cell A1...

hi I have a date range in column A and I want to sum each of the values in H and I is the date in A matches Z so but my formula doesn't seem to like summing H and I. It work fine with one of the columns but not both. The formula I'm typing is =SUMIF(A:A,Z4,H:I). Seems straight forward but i...

I used to be able to move rows by typing Shift-Spacebar to select the target row, Ctrl-x to cut the row, moving the cursor to cell A whatever and typing Alt-I > e to insert the row in its new location. This is no longer working. Does anyone have any idea why?