Programming

Importing and exporting sheets from spreadsheets
I have a spreadsheet with information stored on Sheets named St1, St2 and St3 The spreadsheet retrieves data from specific cells on the sheets and gathers them on a summary sheet. What I would like to do is be able to import St1, St2 and St3 from other similar spreadsheets so that my spreadsheet can summarize... 17 Dec 2009 14:51

user form
Can you change the caption font size of a user form? ... 17 Dec 2009 18:12

VBA Editor
This may seem like a foolish question, but. I've been working with the VB editor and have gotten quit use to seeing the Project Explore on the left side of my screen and the code showing up to the right of it. All of a sudden I can only get the Project Explore and code to show up in full screen modes or witht... 17 Dec 2009 20:26

variable target address
i have two worksheets...one that has a list of names , and a detail sheet that has data for each name. i am looking to have a macro that would create a third sheet that summarizes the detail in the data sheet for the name that is double clicked in the name sheet without having to create a separate macro for ... 17 Dec 2009 14:51

Creating several TextBoxes (Shapes) with cell references as contents
Dear Experts: below macro grabs the contents of cell B7 and displays it in a text box (shape, not a control!). The formula is a cell reference so that the text box contents is updated whenever the respective cell changes its contents. I would like to have the macro expanded so that several input boxes are cre... 17 Dec 2009 12:38

Select one cell insteade of a range
Is it possible with VBA the make a sheet select only one cell at a time when you drag the cursor around the sheet instead of the normal function of selecting a range? ... 20 Dec 2009 09:14

Assign faceid to image on userform
create an empty userform and put this code into its code module. I tested it with Excel 2007. '------------------------------------------------------------------------ Option Explicit Private Sub UserForm_Initialize() create500Images ' we create 500 image controls SetFaces 1 ' we put the faceI... 18 Dec 2009 04:00

OLE Problem on Opening
Hi All, I have searched everywhere but cannot find a solution to this. I have a c.6mb .xlsb file (c.60mb in .xls) which I am trying to open in xl 2003. However everytime I try to open it it starts to convert the file then just gives me the following warning "microsft Excel is waiting for another application to... 13 Jan 2010 06:33

Auto Fill Text Box
I am having trouble getting a text box to auto fill from a choice made from a combo box. Combo Box Name is Address_21 Text Box Name is City_1 My code is as follows: 'Auto Fill CES Spec Written Office Private Sub ShowCity_1() Dim Address_21 As Variant Dim City_1 As Variant If UserForm... 17 Dec 2009 13:45

Copy Active Range from one workbook to another
i need a few lines of code to determine the active rows in columns A and B and copy from one work book to another. i kind of understand the loop, but not a lot. i need to select/copy the active cells in workbook one (always Columns A and B) and paste them in the next blank row in Column A/B of workbook two. ... 16 Dec 2009 21:21