Search results for query: *

Hi, Could anyone advise how I can use VBA (which would be included in an Excel VBA module) to add the same logo image to the front page of number of word documents that are stored in a folder eg select the folder where the word docs are stored open the word docs one at a time add the logo to...

Hi, I have two tables, one called 'Contracts' and one called 'Risks'. I have built a Report which includes the Risk table data and that report works fine. I have also built a report based on a query using the risk table data and that also works fine. How can I include data from the contracts...

Hi, I have developed a small database to hold contracts information. There is a main form named 'Contracts' which has several tabs. One of the Tabs is named 'Documentation' and it contains a subform (named Documentation SubForm) to hold all the documentation associated with a contract - the...

Hi, It it possible in Word to associate or connect a key with a given paragraph formatting style. Many moons ago, I remember being able to do this with a desktop publishing package (ventura?) Any suggestions gratefully received. Regards Pete

Hi, Any suggestions on what the vba code is to cause a workbook and Excel to close without a save prompt. I would like to attach this code to a command button on a userform so that when the user clicks the 'close' command button, the userform ends and Excel closes without any further prompts...

Hi, I know how to change the background color of a userform using VBA - but is it possible to change the color of the top userform title bar? eg the bit that holds the caption text? Regards Pete

Hi I have been using:- Screen1.show to display a typical userform. (Where Screen1 is the name of an existing userform) Does anyone have any suggestions on how I can display the same form by using a userform name (eg 'Screen1' which is held in say cell A1 of a worksheet? Regards...

Hi There, I have been using the code below to add a label to a frame within a form with its attributes determined by cell contents on a worksheet. The code works very well but I would like to use alertantive frame names as opposed to Fra1 such as Fra2, Fra3 or whatever. When I try replacing...

Hi There, How do you write the names of all userforms to a range of cells in a work sheet? Or alternatively, in Excel how can you check that a particular userform exists? Thanks Pete

Hi There, Here's a challenging question - anyone know how to include a comments field or comments box on a user form, so that when the user moves the mouse over a label or any object for that matter, a comments message is displayed? [mouseover perhaps?] Given the excellent responses I have...

Hi there, I have a number of Dim lines which are very similar. Any suggestions on how I would compress these lines by maybe using something like a for next loop?? The code is:- Dim lbl1C1 As MSForms.Label Dim lbl2C1 As MSForms.Label Dim lbl3C1 As MSForms.Label Dim lbl4C1 As MSForms.Label Dim...

Hi, Just a quick question - how do you remove a userform from an application by using VBA code? Regards PCU

Hi, Building on the excellent help provided by Tony Jollans and Fane Duru, I can now generate a whole range of objects on a new userform - fantastic! However, when I add a frame to the userform it covers the objects rather than enclosing them. I have tried altering the order of when the frame...

Hi There, Just a simple Excel/VBA question which I hope the forum can answer. What is the VBA code that will add a new control such as a commandbutton or a textbox to a userform? Thanks in advance. PCU