vba forms

Good Day Everyone; I have a sheet named Products, the sheet has three columns namely Date (column A), Product Name (column B) , Amount (column C). I created a VBA form with a Listbox, a combo box (with all product names), two text boxes to insert a start date, and an end date. The text boxes...

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

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

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

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

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

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

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