Search results for query: *

Here's my button code, and I want to see if I can do something different so I don't have to repeat the same code for each of my 14 buttons in my option group: Private Sub grpS1_LostFocus() Dim intCount As Integer Dim lngRed As Long, lngBlack As Long lngRed = RGB(186, 20, 25)...

I have a query that produces data like this: name date q1 q2 q3 q4 q5 Subject A 3/1/08 1 2 1 2 1 Subject A 5/3/09 1 2 1 1 2 Subject A 6/4/10 2 1 2 2 2 Subject B 4/5/08 1 1 2 1 2 Subject C 2/7/09 1 2 2 2 1 Subject C 3/8/10 1 2 1 2 1 q1-100 represent responses to questions. I am only...

I have a 2 column table that looks like such 1 apple 2 banana 3 orange 4 tomato 5 strawberry This table could have up to 15 rows but may have as few as 3. On my main form I have an option group with 15 toggles and values of 1-15. I would like to make the togglebuttons.visible = false for rows...

The project is a modification of Duane Hookom's At Your Survey and questions are presented in a series of subforms each on a tab control. I would like to make a label visible on the main form with a colored background when the questions for a given tab have all been answered. As questions are...

I need to be able to click on a link (word doc) in excel and have Word launch, and open the linked file. These links would ideally be visible in a userform, with the ability to be clicked. Other options for the WORD link in Excel would include doing the following, all from within Excel: -...

Anybody out there ever used this program? If so, I would appreciate any feedback / insight into this program ! Thanks, sky

Trying to hide rows with no values (but contain formulas, conditional formatting) from the bottom up in a three page worksheet prior to printing. During execution, after row is found with data, exit sub. I have tried this and while it works, it's painfully slow... With...

Trying to delete rows with no values (but contain formulas, conditional formatting) from the bottom up in a three page worksheet prior to printing. During execution, after row is found with data, exit sub. ok, here's what I got so far... The code below doesn't work probably because each blank...

I would like to create multiple invoices within the same workbook. I have Invoice #1 in my workbook. Invoice #2 begins as a copy of Invoice #1, then the necessary data is changed. Each of these invoices need to link to a single, flat-file database in Excel. So far so good. Here's where I get...

I have an Excel worksheet containing cells in which my users input, among other things, contact information i.e. company name, address, phone / fax numbers, etc. Is there a way to provide a button in Excel so that when clicked it would spawn the Global (dep't wide) Outlook contacts list...

I have a workbook that contains 11 sheets, several VBA modules, and a couple of userforms. Total file size is 530k. No charts, few images. Seems a bit bulky. I know Excel Bloat is a common problem in workbooks that are shared (across a lan for instance). For example: the file size for a...

I have an image (logo) that repeats on several sheets in an Excel '02 workbook. Removing all copies of the image reduces overall file size by 100k. Is it possible to create "aliases" or "instances" of an image object, to keep overhead in check? Any help would be much...

I have a userform that contains a listbox. This listbox has for it's source a range of cells on another worksheet. The user selects from this list, and the data is placed into the active cell. Many of these source cells are multi-lined (alt + enter). The listbox on the userform shows these...

Using the before print routine in Excel 02, I am trying to set the print range to contain cells with data, and exclude those that are blank. I have found several useful threads on how to determine the last used cell in a worksheet, but the worksheet in question is a (3) page template and...