Recent content by sf123

Is there any way I can have my asp code send an automatic email to me when user submits a form? Immediate replies appreciated. Thanks!

I'm running a module, without a form from Excel. Once I finish the program I need to terminate the program. If I type end it works but I get an error, as follows: application-defined or object-defined error I'm assuming because there is no form and it is trying to end the form. If I take out...

Thanks anyway! Generally, I've found this forum to be the most helpful with all my questions.

html. no dll's

yes

I have a name and password textbox in my form. It is a hardcoded password, and anyone can see it in the code by going to view source. How can I hide this information?

Is there anyway I can program a menu to be attached to an excel toolbar every time my program runs. Right now I created a menu bar in excel (tools, customize) and I attached a macro to it. The macro calls my form and the program runs. But when I give this program over to the user, they won't...

This still leaves me with problems. Let me explain the flow of my code. 1. user enters criteria and presses submit 2. submit function calls a few subs a.promp user to enter a sheet name (input box). create new sheet with sheet name c. fill sheet d. create chart based on info in sheet My...

That doesn't help me because if the user presses cancel, it keeps going in an endless loop. That loop works fine if they enter invalid input and press OK, then I want to force them to first enter valid input before pressing OK. If the user presses cancel, I want to exit out of the whole program...

How do you program a cancel button of an input box? -sf

I assigned a macro to a menu in my toolbar. The macro calls my program and displays a predefined chart in my excel spreadsheet. The program ends without any runtime errors. After displaying the chart,however, I get the following error in excel: application-defined or object-defined error What...

I filled up possible selections in a combo box by looping through contents of an array. I want the value of what they selected by the index of the array. Eg: if user selects red, I want to always refer to that as 1. if user selects orange, I want to always refer to that as 2 etc. How do you...

I know I am in the wrong forum for this but it has proven to be very helpful. My problem is that I am using visual basic for application in excel so I don't have the validate. (I checked in vb5&6 and saw that there is validate over there). If you have any other suggestions of how I can do this...

rdavis: There is a validate event in Textbox? I tried the name of my textbox. but nothing of that sort poped up. What do you mean?

I called 5 subs from my submit_click. If I do exit sub, it will just continue with the rest of the code which is calling the next sub. I want all my code to halt (but not end because I still want my form to be running), bring the user back to the form, let them resubmit and have code start from...