shrink

I'm sure this is something pretty simple for everyone but I'm having the hardest time getting it figured out. I have created a userform that has a combobox. How can I assign a list that the user can pick from when they click on it. The list is on another tab named "Employee Data" and is in...

Hi, I need to invert text in cells up down side and I have found the best way to insert textbox and invert it then linking it to the cell. I try to make the text in the textbox to shrink to fit the size of the text box, thanks in advance.

How to shorten the length of the words in excel, Foreg. if i have words of 50 characters and i want to shrink it to 25 , is there any formula to do so?

Hello every one Thanks for accepting me in your respectful forum. I want to merge the contents of several cells in one in way like that : Range("b1")= Range("a1") & Chr(10) & Range("a2") But I want to determine the font size for every line to be equal one in the original cell after SHRINK TO...

Hi I need to have an full screen image shrink to around 25% of its original size and appear in the bottom right corner. The shrink/zoom animation only seems to be able to put this centrally, which, unfortunately, is no use!

Hope all can understand what I'm looking to do. I have this sheet called Main A B C <colgroup><col style="mso-width-source:userset;mso-width-alt:1308;width:28pt" width="37"> <col style="mso-width-source:userset;mso-width-alt:4522;width:95pt" width="127">...

Hi, I'm new here and this is my first post. I am trying to do something that I'm not sure is possible. I have two pivot tables on the same sheet and everything works well, except when I refresh them and new rows are available. One or both of the PivotTables may grow or shrink. I would like the...

I managed to put together a macro that can group columns based on the cell's selection. I have it based on every month... but I don't know how to make it look compact. Here's what it currently looks like ( just shortened a bit for your sake, I'm not listing every month... ) Dim ws As Worksheet...

Could someone please let me know if it is possible to shrink this countif statement? It becomes too much to handle since I have to copy it for multiple different rows. The A1 stuff is to know if the sheet is "active" (if there is a different way to do this I am all ears) it would need to stay...

Hi there, I use excel 2003, and have a 15MB s/s. A colleague of mine pasted in a pivot table from a previous version of the same s/s bloating it to 21MB (the "save data with table layout" option was ticked by mistake). Removing the pivot table has reduced the s/s to 18MB - but not to 15MB. So...