Recent content by innov

Thanks, Combo. Let me experiment with this concept and I'll report back. For the record, I ALSO agree that it's not the best for code protection. I had reasons for being tied into this platform in the beginning (no good excel grid controls for .net at the time, etc.), and I am migrating, but...

Anyone else have an answer to the technology question. Skip, its been awhile but I usually was impressed by your vba prowess. Having a bad day?

I don't want to get into philosophies but suffice it to say that I have a vested interest in keeping my licensed code centralized.

Hi Skip. Thanks for the quick reply. I trying to detect mouseover events in OTHER workbooks without putting vba code in them (and therefore needing them to be .xlsm files). I was hoping to put activex image controls in them (without code) and then monitor the mouseovers from my main application...

Hey Folks. SETUP: I know how to: (a) use image mouseover events within a worksheet module; and (b) How to invoke/use an application-level eventhandler to track application-wide worksheet & workbook events.. QUESTION: Is there a way to create an application-level or workbook-level...

Here's another approach that might work, but I have not been able to get it going either: using a SINGLE combobox and modifying the list. Upon selecting from the dropdown, the _change event fires. In the change event, I modify the list and redo the .dropdown to no avail. If anyone can help...

PH: I did try the AfterUpdate and it did not work either. Skip: Does "WORKS!" mean that you got the second combobox to dropdown without clicking on the second label? That's my object. Thanks.

Skip, I guess you saw that I do indeed have 2 comboboxes but they are hidden. Just for context, I have a floating (non modal) dashboard for navigation, etc. and upon clicking on a label, dyamically display JUST the dropdown (again to look similar to a pop-up / dropdown menu in a webpage. I...

Gerry - I believe that is the issue. The Change event must finish before focus can shift. I tried firing off an asynch task with ONTIME (in a half-second or so), but that did not work either. Skip - I'm not sure what you mean. Can you be more specific of offer an example?

I have searched for an answer to this for years as well. Here's what I know. PDFWriter in Acrobat 5.0 DOES let you use the PrintToFile properties of the PrintOut method. Releases 6.0 and on require either: (a) user intervention (the saveas dialog); (b) use the Distiller COM object which requires...

Hey Skip. Nothing burst here. I DO want the user to make a selection from the 1st dropdown, and based on the selection, display a second dropdown. As you can see from my sample workbook, I'm using the _Change event on the combobox to trigger the 2nd dropdown, but can't get it to display. BTW -...

I see how my link came out due to spaces. Here it is: http://innovient.com/Downloads/cascading combo test 2.xls

Skip and Hugh, Thanks for the replies. Skip: That's exactly my problem. Once a dropdown is displayed, I cannot display another without some user intervention. I have tried setting the 1st combobox to visible = false, setting focus on the 2nd combobox, you name it. Attached is a simple set of...

Howdy folks. I have exhausted all my efforts on this one. First off, I know there are posts for "cascading comboboxes", but they are not this situation. I currently have a combobox that employs the .dropdown method upon clicking on the combobox (no big deal). Upon selection from the dropdown...

Hi lebforces. Yes, I got to the bottom of this. Turns out that you can only use the PrToFileName option with the PDFWriter up through Acrobat 5.0. In 6.0 and up, while you can still use the PDFWriter explicitly through a dialog, you must use the Distiller in VBA if you don't want user...