Search results

I have created a watchwindow, which pops up based on a macro that I created, tied to a ribbon. How do I format individual parts of text within the watch window? For some reason when I am in the Properties Window when I try to bold certain text all of the text becomes bold. Your help would be...

Hi - I have a date April 1, 2021 and a year that I want it to tie to, 2017 - I want to pull the month from the first cell and then pull the year from the second cell, so that in the third cell I have April 1, 2017. If someone could help me out I would greatly appreciate it.

This is exactly what I wanted. Thank you!

Thank you very much for getting back to me. The reason why I want this prompt is because I am creating a sales tracking sheet for my brokers. Each time the open the file and are asked to "save as" I want them to have no question of how to name the file. In regards to your script above. Do I...

I am creating a file and I would like there to be a prompt so that when a person closes the file (will be set as a read only), a message pops up saying how the file should be named - very similar to how you are asked whether or not you are sure you want to save a file before closing if you...

You were correct, I was using ActiveX. When I made the switch I was able to find the control tab and link the cell. The one last problem that I am having is that I want to create sections, i.e., kitchen cabinets, with three options below, kitchen countertops with three sections below. I can't...

Thanks. Working on it right now. When I right click and hit format control, there is no control tab, allowing me to link cells. Am I missing an add-on? Thanks

I am trying to create a sales sheet so that when my broker selects a finish (i.e. color of the cabinets) in one cell, by placing a "x" in the corresponding cell, there is a prompt that comes up saying that no more selections can be made. I also don't want the broker to be able to insert another...