Search results for query: *

Hi Rob (and everyone), Your last post realy seals the decision, as I need to have an active button copied when the if activecell.entirerow.pagebreak=xlPageBreakManual then... condition is met. Thank you.

Hi Rob (and everyone), Rob thank you for your post. Your second suggestion would require less work and is a good fit for the requirements; however, It doesn't seem to work. I have a row A7:M7 that I would like to repeat at the top of all subsequent pages. When I place this in the Rows to...

Hi everyone, I have a worksheet that contains (among other columns) a description column. Each description cell in this column wraps its' text. I would like to test for the condition when the text in this cell exceeds that which can fit on page one and subsequently moves to page two. If this...

Hi Rob, That is a cool idea driving the user-driven process with a macro call. Thank you for this idea. Wow using VBA for only a week now and I have learned a tonne. Thanks. Steve

Hi Mike, Thanks changing the Private keyword to Public did the trick. When in the macro, I also had to reference the Userform when calling the procedure like: Calendar.changeValue Thank you, case closed ;) Truly, Steve

Hi Rob & Mike, Thank you both for your valuable input! I most like your idea of the UserForm's Tag property, so that is what I have gone with. Rob I also now understand the functionality of the hidden text field on the UserForm and I too agree that it would keep a 'more self-contained' result...

Hi Rob (and Forum) Thanks for the post Rob! Yes your divergent approach may work. however, I don't see how this helps me communciate between the Excel Macro and the UserForm. In my scenario the user is click on a graphic that is contained with a cell of Excel. This graphic has a Macro...

Hi Mike (and the Forum) Mike thank you for your post! I will attempt to clarify my needs' with the code. Since my post last evening I was able to get the application functioning somewhat in the way I desire. The current functionality - as illustrated below - makes use of a global/Public...

Hi Dev Community, NOTE (I have also posted this under the Excel Forum, so if you have already read or responed to this post in the Excel Form please don't waste your time) I have been trying to locate a way to pass a variable or call a sub routine of an Excel 2002 VBA Userform, and so far i've...

Hi Dev Community, I have been trying to locate a way to pass a variable or call a sub routine of an Excel 2002 VBA Userform, and so far i've been stifled. The functionality that I seek is as follows: Using a macro(s) to call a single UserForm routine. When this single routine is called from...

Solved this one! I discovered that I needed to set the properties of the instance of the master shape and not the master its' self. Code sample (with hardcoded shapes for readability): Private Sub Document_ShapeAdded(ByVal Shape As Visio.IVShape) ' When a shape is add do the following '...

Hi Everyone, I am very new to developing in Visio using VBA. I am currently attempting to get a Master Shape that is dropped onto a Foreground Page to match its' PinX, PinY, Width, and Height properties to a shape that already exists on the page. I have include some simplified code to...