Search results for query: *

Hello, So essentially what I am trying to do it trap an "insert row" event so that I can prevent it on specific lines, but allow it on others. I know that there is no specific event to trap for insert rows, so we have to go about it another way. One way is to monitor the Worksheet_Change...

Hi, I have a database in Excel with entries on single rows. I have developed a userform to display the content of individual entries and allow the user to make changes. There are some calculations involved in the display so when the user makes a change to one of the properties, the results...

Hi, I'm trying to find a property which lets me know if a row has been "hidden" by a filter or not. I know that I can check the autofilter mode to determine if the autofilter is active, but how do I verify individual rows? Thanks for the help! AC

Hello, I was wondering if anyone knew how to format text (e.g. make bold) within a comment box in Excel using VBA. I want to make certain portions of the text bold. It's easy to do manually, but with the "Macro recorder" it doesn't write any code for the formatting. Unlike the 'cells'...

We are using excel to plot graph; in the graph sheet we add some lines and text. (1) for the lines, in the "format autoshape menu - size" when correcting the width to 0 cm and clicking ok, the value for the width is still 0.01 cm (2)when ploting the graphs, the lines and text box are always...

Hello, I am trying to make an interactive macro where the user is able to select cells while a userform is prompting him to do so. Similar to the way that Excel allows you to create a graph. When entering data, you can click and drag your mouse over the desired region and the formula will...

Hello, I've created a VBA program within AutoCAD which creates a graph based on user input values. The program contains a class for the graph itself and a class for each curve that is plotted. It works great within AutoCAD, but I would like to extend the functionality to within Excel. That...

Hi! Can anyone help me to call the DDEDIT text box from my VBA code? For example, if I have an object of type ACADMTEXT called 'myText', I'd like to activate the text editor so that the user can edit the text. I know that I can give the user a prompt and then assign the value to the...

Hi! I need some help recovering a document. I was typing a report when all of a sudden I must have accidentally hit the 'alt' key and kept typing and when I looked up at the screen I had quit Word without saving the file!! In the options inside Word, it is set to save an autorecover file...

Hi! I have an old document that was created using WP5.1. When I try to open it either in Word 2000, or WP8, the conversion messes up all the tables and stuff. The only way I can get the correct formatting is by opening it with 5.1 (I had to pull out my old 5 1/4's and re-install it and...

Hi, I was wondering if anyone knew of some program that could convert AutoCAD files (.DWG) to another type of image file such as JPG, TIFF or GIF. JPG would be the prefered conversion though. Thanks for the help!

Is there a way that I can supress text-wrapping for a particular word, or that instead of wrapping at a hyphen, that it wraps the whole word? e.g. at the end of my line I have "LARSON-DAVIS" and only "DAVIS" gets wrapped. I want to entire word to stay together as a block...

Hi! I have a bunch of bits of text stored as Autotexts in Word, and when I come to insert them into my document using VBA, a maximum of 255 characters are returned (it's not really a bug, I saw it documented in the on-line help). Does anyone know how this limitation can be overcome (other than...

Hi, Can anyone suggest a good complete book on VB or VBA, that would discuss topics from beginner/intermediate levels to more advanced? I found the book VBA Developer's Handbook, 2nd Edition by Ken Getz, Mike Gilbert on Amazon which seemed like a very good book. So if anyone has any...

In my macro, I shell to dos and run a program. But if the program isn't in the proper location, I obviously get an error. I want to be able to prompt the user and allow him to locate the proper location of the file. Up to here, everything is fine. My problem is when the user enters the new...

Hi, I need my macro to shell to DOS, run a program (which just translates a binary file to text), close the shell window and then continue running my code. Since the "Shell" command runs asynchronously, I had to put a "wait" command in there for now, and on top of it, the...

Ok here's yet another question... When the user closes the spreadsheet, I don't want excel to ask me if I want to save my changes. What I tried was this: Private Sub Workbook_BeforeClose(Cancel As Boolean) Workbooks("myWorkbook.xls").Close (False) End Sub but the problem with...

Here's another question regarding toolbars: Is there any way of greying out custom toolbar buttons? Like for example when there are no documents opened, the "save" button is shaded out. If it's possible, where do I define my condition? Thanks in advance!

I'm trying to figure out how to know when a specific button has been pushed on a toolbar. The reason for this is that if I open my document containing macros manually, it will display a message (instructions). However, if the user pushes a toolbar button associated with the document, I don't...

Hi, I'm trying to automate a report in Word based on data entered in an Excel spreadsheet. So far everything's working, I just need Word to look at a specific cell in excel and write a sentence based on what it finds. For example, I know this is wrong, but this is what I tried: If...