forms

Good afternoon. I'm hoping you all can help me (again). I have a directory that is a repository for forms created in excel. All the forms have the same format. Re repository may contain hundreds of forms in various stages of completion. A form is "complete" when all the required reviewers...

Hi guys, I'm currently working & learning to play with VBA and create certain command button and userforms to ease some of the job. So I've been working on this forms and get stuck with "Compile Error: Method or data member not found" The idea is to have 1 command button on the 1st userform...

Hi Everyone, I have two macros to change formatting and formulas and want to assign them to a Forms Control check box. I want one macro to run when checked and the other when unchecked. Thanks!

Hello All, Hoping someone can help me out as i have been unable to figure this out and google searches haven't turned up anything for me. I have a protected workbook(wb1) with forms and associated vba code. The workbook opens other protected workbooks(wb2) and allows users to perform certain...

ACCESS 2013 I have created a form to pull out information from a Query. In this form I have a text box to fill out with certain field information (e.g. company name). Once I hit Enter or click in my search button the form should be getting updated with the information matching the field that I...

Hi, I am trying to create a Macro that will select certain data from multiple excel files and merge the data into a new sheet. For the Macro, I will already have open a new Excel Workbook with Sheet 1. This is where I want all of the data to be merged to. Sheet 1 looks like this...

On a worksheet, I have created a MS Forms 2.0 Frame and added several commandbuttons onto it. But how can I code some events into the commandbuttons? I can't locate their names and appearance in VBE and elsewhere. The reason of using Frame is to fix the positions of a bunch of already-made...

I have just downloaded an example to write to PDF forms and to find out ONLY it works on Adobe Acrobat Pro (or above). Anyone who have previous experience on writing PDF forms (with PDF Adobe reader only) with VBA and save the original form under different names !? Any suggestions !? Thanks.

Can anyone tell me how to create a floating button in excel form which always stay on the top of forms either we scroll the downward on upward. Or can we make a ribbon control on in vba form.

I have an excel worksheet set up as a form in a workbook. from that form i upload to a workbook on our main server parts of it that I need to log. I want to edit this form and change what it uploads. <tbody> CosCode Description Startdate EndDate Rate UoM Total TestCode Generator 1 of 2...

Hi All I am curently updateing my "Excel Database" to a MS Access Database. when you open the Excel Workbook all the data is copied from the database into the Excel workbook. All new records into the database is via a Excel Form as below. <code class="bbcode_code"> Sub...

Hi, I want to be able to provide people with a template which gives examples or a description, which they can fill out and copy - to be able to paste elsewhere. But the template that copies only includes the item and the answer (not the description) Eg. Name: (Your Full Name) Address: (Your...

Hi. I'm really struggling with this and I'm hoping someone could help me. I have a couple of dependent combo boxes in my forms, and it's storing the data in the table as id's instead of values. I need the values in the table, not the id. I will be exporting this table and sending it to a 3rd...

I have a repeating excel form that I fill out everyday. I am trying to create a page in the workbook that will collect all the data from each form and create a table by dates and particular cells on forms. If anyone has any ideas I would greatly appreciate any advise or suggestions. Thank you,

Hi I have this error happening for last one day. Its been working for 4 years. Error happens when its reach line Workbooks.Open (strFolderA & ak.Worksheets("File List").Range("A" & vRow)) What is the process its doing ? 1) Multiple forms of excel file in ENIR update folder 2) Copying...

Hi, I have a form which has shift information on it. Name, Date, Machine etc. I have created a small table for machine targets which looks like this: Machine, Throughput, OE, JE, OEE Control 1 77% 70% 96%...

Hey there, new to the forum. Been working on an excel project and I am having some difficulty figuring out how to go about what I need to do. What I am trying to build is a program that lets a user select various options as they build a vehicle. And by selecting one engine, it grays out all...

In the sheet "Our Data" below I have data that i pick up from another sheet ("NData"), shown in the 2nd screenshot below. I have two option buttons on my form opnDaniel(Daniel) and opnMelissa(Melissa) a text box(txtServings) that gives me the amount of servings of the food i want to add and a...

Hi, I'm asking in the 'other' section as i'm mainly looking for this to work on a webpage/intranet than Excel/Access, but if you know how to do it on Excel i'd love to know too. So, i'm trying to make a fillable form which you can then copy and paste elsewhere. e.g Name: (please include your...

Hello, Was wondering if anyone knew of a way to have an Excel Form inherit the data validation built into certain fields in an Excel Table. Thanks. Tom