forms

Hi All I am new to Mr. Excel and this is my first post. I have been following the forum for time now. I have a question in regards to advanced excel. I am developing a automated system to generate a attendance report. Here is the scenario : 1. There are 9 Team Managers, each will have a...

The excel auto form function for adding, deleting, editing etc is more or less what I am after for a workbook I am trying to do. The book is to compile a data base for results for testing water. The first part is for logging names, dates,equipment etc. No problems there they fill from 1st form...

Hi, One thing I really liked about the Numbers app for iOS was the 'create new form' function. I liked how you could input multiple sets of data on one page, using the form format, and it would copy across to another page. Is it possible to make similar to that on Microsoft Excel?

Hi, I have a code which is activated by a button click. After several seconds of run, I show a form containing two textboxes named TB1 and TB2. How can I store the values that the user enters in TB1 and TB2 into two variables named respectively TB1val and TB2val for example, after clicking an...

Hi, I am very new to this forum. I am new to VBA although I am quite experienced with Excel. I would really be appreciative of anyone who can help me with the following, or at least guide me to the resources/functions I should be looking at to achieve them: I have a master file from which I...

hi guys can anyone help me in figuring out how to insert filter in access 2007 reports based on start date n end date ???? i am stuck in this please help me

Hi I would like to insert the value on a form (textbox) to a defined table. The textbox has an expression within it. Many thanks

Hello - I am trying to find a solution similar to mail merge, but more streamlined and available immediately upon entering the data. I will have several staff members performing initial health screens. I would like to use a form for staff to enter required information. This information needs to...

I am looking at deploying a Excel VBA solution to a client. The solution works extremely well in Excel, but now we need to deploy it to 150+ sites, where each will need to be installed on the local network. I would prefer to deploy the solution as a browser version instead. The snippets of...

Hi There, I need to submit one form & then submit a second form that only appears after the first is submitted. How do I refocus the .document reference to bring in the new objects created after submitting form 1? Code is below, along w/ a list of all reference libraries I'm using...

I have a spreadsheet in which I need to create a dialog box, form, or field-entry box for simple end-user data entry that automatically adds entries to the bottom of a table. My end-users are very inexperienced using excel and I want to design something for them that makes for simple data entry...

Hello I've got code which creates a new worksheet with the name of your choice (an employee's name) with a view to creating a staff database with individual records. The next stage of the process is to input all their details. At the moment, these details are inputted on to the next available...

Hi all! I'm new here and for the most part have found what I've needed but I'm stuck with this one. Basically, I've got a form which populates a Master worksheet by inputting the data into the next available row. I also want this data to appear on individual records (so the data on each...

I have workbooks that all used a macro that called a form. The form and macro are all in the PERSONAL workbook. Now whenever I open the workbook, two extra workbooks open with the form information. Its useless and confuses my colleagues. Why is this happening and how can I stop it? Ann help...

Hi, i am trying to display updates of a process to user using listbox. That is if user hits a command button i will add few lines to the already existing data in the list box using .AddItem. but after i did the list box always shows top lines and not the newly added lines in the bottom. Is it...

Hi, Does anybody knows how to get access to the sheet and modify cells when a macro form is opened ? Thanks PBA

Hi, I am trying to create a VBA script for a shop. The shop needs to check the stock of a product in a warehouse which is linked to the database. I have a Sheet named 'Warehouse' where there will be a list of items that are in stock. I need the VBA script to have a combo box where the user...

I'm getting multipage in form to work very nicely, I press a button it adds a page, copies what's on that page and puts it in the new page. I've posted my code below, someone can probably use the Add delete functionality. However, the problem arrives when you add an additional multipage on the...

I have developed some macros in Excel 2013. When run in Excel 2007 the ActiveX controls go bezerk. I can think of two options: (1) convert to Forms controls. How to do that easily? (but fonts are tiny and no background color) (2) perhaps recreate the ActiveX controls in VBA (not sure though)...

Hi So I will explain in more details, the following formula downloads data from Google Analytics for a certain period ...