vba forms

  1. S

    Running VBA macros in a shared document

    I have an excel workbook which has several VBA forms with macros running to handle the information inserted by the user. Everything runs well until I define the workbook as shared, allowing others to make changes to it. Once defined, one of the forms aborts with the following error: 'Run time...
  2. E

    What am i doing wrong ?

    WHAT AM I DOING WRONG I am trying to make a form in Excel that can update different tables on separate sheets depending on which sheet has been picked in a ComboBox. Can anyone please tell me what I am doing wrong: Private Sub CommandButton1_Click() If ComboBox1.Text = "R&D" Then...
  3. R

    VBA help

    I have a form in an accounting program I'm working on where a user can input a transaction. The form allows the user to select an account from a combo box, input an amount, and using an option button select whether it is a debit or a credit. In accounting debits must equal credits before you...
  4. B

    VBA Form to Filter records based on condition

    Hi all;<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have a list of records that I want to work with through VBA form.<o:p></o:p> <o:p></o:p> for ex: below records list<o:p></o:p> <o:p></o:p> <TABLE class=MsoNormalTable style="WIDTH: 160pt...
  5. H

    Help with Time Statement

    Hello I'm working on creating a time stamp for work. Currently we are using a paper time sheet and I believe it would be simpler if we used excel. Below is a statement that works for the date S T A R T C O D E Private Sub UserForm_Initialize() 'adds date automatically Me.txtDate.Value...
  6. H

    Help with multi page form

    Hello I am creating a multi page form, I'm on the 2nd page and I believe it will end up being a 3 page form. The opportunity that I have is that the 1st form, the information is being transferred to a sheet named AppDB in columns 1 thru 12. The second form (a continuation of the first form)...
  7. T

    Is it possible

    I have created a basic data entry system using a VBA forms, at the moment I have VBA entrying the text into the cells i have told it to enter into. What i was wondering is, is it possible to have the data enter table but also send some of the data into an e-mail in a set format? I am new to...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top