back

Is there a code that I can use to go back one tab stop on a userform?

Hello there, I have a kind of simple template and I would like to store it in VBA. Usually what I do is record a macro and then copy the value in the formula bar and past it back. That gives me the code of what is in the cell. I do this with all the active cell and job done. When I run this...

Hi there, I am creating a calculator in Excel which I need to only go up to 99999 and once it does so I need it to go back to 0. For example....99994 + 8 will return a value of 2 as opposed to 100002. Any ideas on how I would do this? Thanks in advance

I am currently using a simple formula that looks like this =A1&","&A2&","&A3 and so on until A30 My cells have vlookups in them and some of them come back as blank. Because of my fomula i end up getting something like this ,,,,342,,,,, Is there anyway i could skip the blank cells Thank you...

Hi, Please would you be able to help with a formula. I am trying to bring back the correct result as follows. 1 2 3 4 5 6 7 8 9 10 11 12 Consultancy 10000 10000 5000 6000...

Once I type any text, Drop down list become inactive and to make it active need to come out from the Drop down and go back again to make the Drop Down work.

Dear All, I have a file created by an external in which the toolbar is hidden. I have no options to bring it back. Do you have any ideas. Thank for he support. regards Klaros

Dear Sir I have a worksheet which has following sheets; Sheet1, Sheet2, Sheet3, Sheet4, Sheet5, Sheet6 All these sheets have buttons "back" and "next" I have hyperlinked this to next and back sheet but what it want is that; Once I press "Next" on sheet 1, user jumped to Sheet2 via hyperlink, at...

I am using Windows 10, Microsoft Office 365 (2016). I have written macros in older versions of Excel and had no trouble, but now I am stumped! I need help creating a macro that will change the active cell in Excel to a different color - RGB (R204,G102,B255) which is in the purple color range. I...

I have several columns of data & would like to display only a few. I can manually hide them but it's a pain. I use the advanced filter & do the "copy to" another location thinking only the specific columns being put into the "critieria range" would be displayed but all columns come back. Is...

what function would i use to have a cell in another column reference back to another cell in a differet column?

I'm attempting to augment Jeff Weir's Easy way to back up CF formats sub but I'm running into an issue when more than one CF is applied to the same range. The excerpt below loops thru both the various ranges with CF (rngUsed) and each FormatCondition that is active in that range. However, not...

Hi everyone - trace dependents seems to be stuck turned on. I've tried the normal going into formulas and clicking remove arrows, but then as soon as I scroll to another cell with dependents, it comes back. When I select everything in the sheet and click "remove arrows" the message I get is...

Greetings community. I'm very new here, and I am fairly new to VBA macros. I understand most of the basics, but I may need answers dumbed down a good bit. With that disclaimer out of the way, here is my questions. Each customer has their own detailed checklist of processes (so separate...

I have a text string in excel that is a series of notes delimited by <> following each note So an example would be: It is going well - I hope; we'll know more next week<>Project is slipping - more to some<>Project is on track as of 7/7/18<>Well, it's back off track as of 7/15<> Would very...

I need to "reactivate"/focus my VBA back to IE. to continue getting data off of various pages without having to log back in to the same page. So right now it is selecting all data on the page, copying and then pasting to a sheet in my excel workbook. I am having trouble getting send keys to go...

Hi Everyone, I am looking for a formula to bring back the column header for the first value in a cell. Here is an example: <tbody> Customer 12/17/2018 12/18/2018 12/19/2018 12/20/2018 12/21/2018 Customer A 800 800 800 515 </tbody> My goal is to bring back 12/18 since it...

https://docs.google.com/spreadsheets/d/1JLq1yaPo5OwFXCldO4ruQKtBaVho1T2A59IQfgLUgOM/edit?usp=sharinghttp://i1275.photobucket.com/albums/y445/DarkJester89/Capture%20Photo_zpsc3qnmomn.png I've been working on this worksheet for weeks and I'm on the very...last..formula. There are 10 topics in...