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...

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

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...

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.

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

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...

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

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...

I have a few forms which are shown based on various triggers. WHat I would like is a way to see which userforms are open and the unload them. I've tried just stating unload Userform1 unload Userform2 unload Userform3 But I get an error message if one of the forms has already been closed. I...

I have a few comboboxes on Excel2000 userforms that have various ranges for row controls and I've set matchentry to complete. The combobox works fine via drop down and if you spell what you're looking for exactly. However when you type in some different text into the combobox it freezes the...

I have a model that calculates a final % by multiplying base data by a series of events in the order of the events date rank. The calc works fine but I've added some functionality that updates the events and causes the model to calc very slowly due to the current vlookup rank method. What I'm...

Say I have a range of values that has various data based on user inputs of a model Sheet1 = Test1 1 2 3 Test2 0 0 0 Test3 -3 -2 -1 I'm currently copying this over with Sheets("sheet1").Range("a1").Resise(3,4) =...

I've been using the code below w/ some success to write the values of comboboxes to worksheets on change. However, my userform just started crashing Excel everytime I combobox was selected. Removing the code stopped the problem. Is there a more efficient method of replicating the below...

I've set up a combobox on a form using properties that set the Controlsource = Sheet1!A1 and the rowsource = Sheet1!B1:B10. How do I get the Userform to update A1 on each change of the combobox and not just when the form closes as its currently doing? Thanks D

I'm looking to load a range of text values from a sheet into a textbox on a userform. Am I even close w/ the below? Private Sub Userform_initialize() Load UserForm1 Userform1.Textbox1 = Range ("Sheet1!A1:A3") End Sub I do not want the userform to over write the range. Looking for...

Is it possible to add Excel Charts to a user form? Possibly converting an existing chart to an image and inserting it? I want to dynamicaly chart the impact of the values entered in the form - so that users can see the result of their input. Thanks. D