submit

I am trying to force the person doing input to enter something into a text field in a user form, in order to submit the information to the main tab. Currently, they can leave the text box blank and submit nothing into the space. There are certain fields that NEED information in order to process...

Hi all, I have a userform that will enter a date into E4 when I click Submit. Cell F4 has a formula to vlookup the date from E4. F4 is not automatically updating when I click Submit. It will update if I click in E4 and press Enter. Is there a way to ensure the formula in F4 recognizes the...

HI Everyone, I need the code for a message box that gives the person 3 options when run the message box needs to say "You have not Submited Data Yet" new line " What would you like to do? Then if possible give the options of "Cancel" "Submit & Continue" "Continue" if cancel just come...

Hi Guys! I'm currently working on a little project. It's a VBA UserForm. The user enter his name, choose between 2 option (for Age +18 or -18) and it send information NAME Private Sub NAMEValue() Sheets("TRACKER").Range("A1") = NAME.Value End Sub For the age (OptionButton) Private...

Intro> I'm new to vba for ie, I've been searching in many forums for days, but I still couldn't find someone with the same problem as me. That's why I'm creating this new thread. Would someone please help? My goal> I want to automate my searches for flight tickets in skyscanner . com More...

I have a large workbook with many worksheets within it. The end users fill in the user-forms and email the workbook back to me. There is a "SUBMIT" button in the workbook that uses VBA code to transfers the data submitted to another workbook that is used as a repository. I do not have any...

What I need help with is the a formula to include specific conditions I have prepared a Workbook with the issue. My membership does no allow me to send attachments. How can I submit an excel file please?

Hello! I am trying to write a macro and the first thing I need to do is log in to a website. It appears that I am able to have the macro open up the website, enter the username and password but I'm struggling with getting it to submit. Can someone tell me what I'm missing here? Dim HTMLDoc As...

Hello I need some help with an input box. The box is a simple user form with 2 fields, Job and Comment and a submit button. When the user fills in the form and hits submit, the values are written to a sheet in columns, labelled Job and Comment. It works fine, however, i want the form to first...

Hi All I have the following code that copies data, opens another workbook, selects a sheet and pastes onto the next available row. It works beautifully. Sub Submit()If MsgBox("Are you sure you want to submit data?", vbYesNo) = vbNo Then Exit Sub Else MsgBox ("If you need to make changes please...

Hi I have the below code, it opens the website www.reece.com.au/myaccount/login, but does not fill in the email and password (Correct information on code has been removed for privacy) I assume it is not working as I have not referenced the correct name in HTML. I assume it is email and...

I have a Submit Button on a Userform that I'm trying to use to pass data from a listbox back into a specific cell on my worksheet. The sequence is as follows: Worksheet_BeforeDoubleClick sub calls the userform Userform displays the list box and user can select multiple options Submit button...

I'm in the middle of creating a vacation calendar that will allow employees to lookup what is available but what I would like to do is allow them to use a submit button to enter there unique ID to that particular day. So for example on Jan 1 we can have 2 people off in the garage and 1 person...

Sorry to ask for assistance but I've been trying to solve this for weeks. I have a table of date (myTable) and in the first column on each row there is a link to a sub table that I'm trying to scrape. I can collect the table data once it is displayed however i have to call a message box to pause...

Hi All, Hopefully somebody can help me with this one, I have a userform that is submitting data to the next empty row of columns "T:AB" but the code is only submitting data to columns T and U, could anyone please help me to find out why? Thanks in advance Jacob. Private Sub...

Hello again forum. Yesterday I've managed to navigate through a webpage via vba, but I can't figure out the last step, or the one before it. I need to click on a submit type button, but I can't figure out how to do it. The problem is, I can't get the element by name, because all 3 share the...

Hey excel gurus, Slightly complex one here...and I'm no excel expert. I have a spreadsheet full of SVN check-in times for a group of programmers, as seen below. Note that it is sorted by revision number, not by name, and that it's in reverse chronological order. I want to assign an "time...

Hello, I have an excel document that I would like to insert a Submit button that will send out the Excel document to a number of people. My thought would be to click submit in Excel and then it will attach the file to a Lotus Notes email with about 5 peoples name automatically appearing in the...

I'm trying to take the data from column "C" (excluding the header) on sheet "Health Form Corrections" and display it into "ComboBox1" on "UserForm1" without any duplicates in the combo box. From that combo box I want to hit "Submit" and have it display all of the data that matches the combo box...

I would like to create a button on a form and on click the button will perform the action of adding the data to the pre-defined table and making the form blank for new data entry. Everyone please help me http://s1172.photobucket.com/albums/r576/m07aryku/?action=view&current=UntiEtled.jpg