Search results for query: *

Hi, We're looking for the most effective way of capturing data in an MS Outlook e-mail and then having the ability to export the data to an Excel file (convert form input into a row of Excel data) Our initial thought was to create a form in outlook and then use some macros to export to Excel...

No luck on the clean reinstall. Re. faultrep.dll I thought that was only involved in deliverying the error message to MS and is not actually associated w/ the error. Any additional fixes greatly appreciated. Thanks.

How would you go about removing all traces from the registry? Any simple way to do this other than regedit? Thanks David

I've been pursuing a fix to this w/ Palm and MS to no avail. The software worked fine on 2000. I've just installed XP pro and every time I go to install the Palm software I get Note the software installs on other machines w/ XP Pro and I've reinstalled as many drivers as I can for my Evp...

Is it possible to replace the actual time frames in a Visio Gantt chart w/ generic month and weeks? I want to have a generic chart that has month 1 week 1,2,3,4 Month week 1,2,3,4. Thanks. David

I'm having a hell of a time trying to clear a multiselect listbox of all selections. Bumped my head against listindex which I'm sure won't work for a multiselect listbox and have been trying to write a loop for selected with no luck. Any thoughts greatly appreciated. D

The combobox is already populated with a string. I just need the ability to preselect one or write in a value. D

I have a series of comboboxes on a form which I want to preselect or preload with data form the spreadsheet when the form is activated. I've tried code in different variations to the below w/ no luck. UserForm1.ComboBox3.text = Range("eventsdatabase!E2").Value D

I have the code at the bottom which currently copies over only rows w/ values in event1 and pastes them in sheets.relativeevents. I'm looking to modify it so that in the values it inserts it replaces and 0 values in the rows that it copies w/ 1. Need to avoid inserting 1s in rows that are not...

This code also changes blank cells to 1. Any way to avoid blanks or leave them as blanks

Lets say I have a range of #'s 0, 1.01, 5.2, 10.2, 0 I want to be able to replace just the whole 0s w/ the number 1 through a comand button. so the above would look like 1, 1.01, 5.2, 10.2, 1 I figure just regular find and replace won't do.

Got it Image1.Picture = Nothing Nothing ? who would have thought! DAS

Last question for the day I'm populating an image on a userform w/ chart which works well. What I can't figure out is how to clear the image. I've tried a few different controls like delete to no avail. Thoughts?

I want to set Excel calculation back to automatic when the my form closes as I do when it launches. I use Userform_activate() when the form launchs but have tried terminate and exit w/ no luck. Application.Calculation = xlCalculationAutomatic

You're a star thanks!

Looking for a more efficient way to copy the formula in I2 on sheet1 and insert into c2:f2 & l2. Using the recorder I came up w/ the below - but running it shows cells being selected and leave L2 selected. I've tried modifying it by taking out the select method but get errors when I then use...

Looking to change the font color which enable changes to a dark grey.

I have a textbox on a form that I'm using to show data that using controlsource - Sheet1!AR12 - I've disabled it so users can not type over it. However, once disabled I can't edit the font. Any work arounds or thoughts? D

Thanks for all the comment on this. I've gone w/ Mikes =SUMPRODUCT((B$70:B$4000=$AAS$77)*(C$70:C$4000)) as it does speed up the calc a bit. Though the sum still slows down as new data is pasted into the table (see below). To clarify a bit I'm looking to rollup (sum) all the values in a...

I'm currently using the arrary below to sum up matches in each respective column starting w/ column C. However, any time new values are pasted into the match range the calculation slows to a snails pace as I guess the match reruns or the sum recalcs. I've tried setting the calculation mode to...