stays

Hi all, On UserForm I have textBox were user should enter school name, I would like, if the name already exists, to get message that the name exists & Focus stays in same TextBox (not move to the next control) Thank you in advance.

I do a Financial Spreadsheet for my boss. Lets say A1 is our revenue. B1 is staff cost. C1 is a percentage of cost to revenue. D1 is the difference of C1 to our Goal of 22.5% Is there a way C1 can turn Red if the Percentage exceeds our Goal of 22.5? Is there a way D1 can be Red if the...

Hi, I have a button on top of each sheet and when clicked takes the user back to the TOC. 'Create & Position Shape Set Shape = Worksheet.Shapes.AddShape(msoShapeRoundedRectangle, 550, 0, 40, 20) I've added following code so that the shape stays in the exact same position when the user...

This is odd. I have a pivot table and whenever I reference to it, it just stays a formula (e.g., "=B47" and enter just stays "=B47"). Within the pivot table, I've turned off "Generate Get Pivot Data" so that it refers to the cells as normal. Calculation is absolutely turned to automatic. The...

Can someone show me how to adapt this so that the dynamic range stays on row 30 but goes across used columns, not rows?

I am trying to return to Cell A1 in a very large spreadsheet however the window will not scroll with the Macro I have created. I do have the Freeze Rows and Columns turned on. The window stays on column BC. Does anyone have any solutions? Thank you

is there a way I can freeze a cell and row that's in the middle of my page. if i have box that is e2-36 to f2-f6 is there a way I can freeze that area? so when i scroll down that area i want to freeze stays in the center <tbody> a b c d e f g h 1 2 freeze freeze 3 freeze...

Hello all, Forgive me if this has already been asked before. I can't seem to find what I need in a search, probably because of my terms. I have a row in a spreadsheet that I would like copied to a row further down. However, as more columns are edited (this is kind of like a running calendar)...

Hello guys, I have a formula =INDEX(Data!A:A,MATCH(EC!F85,Data!B:B,0)) on my worksheet. I know I can copy and paste the formula all the way down the workbook but I am trying to write the formula in another cell; once I do that the formula stays in a text state instead of going to #N/A. Anyone...