forms

I have an excel spreadsheet with the first sheet that acts as a “template form”. I complete the form, and then run my macro that creates a copy into a new sheet and then clears the data and selections from the template.<o:p></o:p> <o:p></o:p> Every now and then the template needs to be updated...

Hi Guys, I am currently making a macro for a button to log queries, I tried to use an IF statement to check if the desired cell is empty, and if not, record the comments on the next cell to the right but it doesn't work, please any help would be much appreciated. See below: Option Explicit...

I have an excel sheet with 7 different 'forms' on it ranging from A1:O43, A44:O77, A78:O111, A112:O145, A146:O167, A168:O189, A190:O220. Each form is on 1 page. If a form is not used, I have made buttons to hide the form on the workpage (code below) but it would still print a blank page (I know...

Hi, I have created an income statement form in access that has a Beginning Date, End Date text boxes followed by Income and Expense text boxes and lastly and Net Income text box. I have tables set up for income and expenses. What I want is to enter a beginning and end date on the form and...

Hi, I do not have any idea about forms. My post might be wrong. I apologize in advance for the same. I have a database. I have written multiple queries for retrieving information from this database. Now I am trying to design a form, assign a query to command button of the form. I have bit of...

I'm working on this workbook that I need to share with two other people. Everything will be working inside Forms with VBA codes. These 2 people will be working on different functions/pages, so there will be no data conflict. But the new Excel Share system (Cloud) does not work with VBA, shared...

Good afternoon, I have been building my db on Access 2010 over the last several months and am pretty new to db building. The intent of this project is to audit and report based on those audits. The audit is quite large. It currently has 18 tables. Some with one to one...

Good Afternoon! I am trying to write a macro that will have text from a row with check boxes open in a new tab as a summary page. This is for a new order form so by checking a box, it would be a product that a user would be selecting. Thank you!

Hi excel gurus! I created a simple form in excel using "check buttons" and "check boxes". I want to copy to clipboard only the selected options by pressing a button. The form looks something like this: Color: [] blue [] green [] red [X] black Fruit: [] apple [X] banana [] grape [X] orange...

Hi Whilst I am quite familiar with creating a list of controls and properties for a form by using code in the forms code module I cannot find a way of doing this for all forms. If I correct in thinking that the userforms collection only includes loaded forms do I have to load all forms and...

I have the Forms 2.0 Object Library loaded. I have a value in a string variable (strNum) I have a new form data object (doNum) when I use: Dim doNum As New MSForms.DataObject Dim strNum As String Dim strMessage, strTitle 'Input box to prompt for opers to query data strMessage = "Enter...

Hi I am not very familiar with the forms in Access... however it will save me someone else time rather than manually data entering all the forms. I have 2 fields that I would like populated by a table I have imported; File number and date received. I have created the form and linked the...

I have a spreadsheet showing a large number of tasks. One task is shown in each cell. Can I use the cells to store the completed scanned forms for each task? I am wishing to drop one completed form into the appropriate cell.

Hi team, I'm trying to set a max limit on my Form Scrollbars (I have 4 unique named scrollbars on sheet "dash_v2"). I have COUNTIFS formulas (in cells) on sheet "dash_v1" calculating total references, i.e. 2 of this, 31 of that etc... Those references are the numbers I'd like to use as a...

I have a form with a button that, when clicked and depending on a separate value, will launch one of two possible forms. dim frm as UserForm 'later If theValue = "edit" then Set frm = frmEdit ElseIf theValue = "delete" then Set frm = frmDelete End If frm.Show 'Run time error 438...

Hey there, Win10, Office 2016, latest updates on both. I can no longer work with forms in VBA. Doing so causes an error, "Component not correctly registered." Microsoft Forms doesn't show as an option in my reference library. I've traced this to a .dll file called fm20.dll. I do have that file...

I tried to search for this in the forum but could not find anything that helped me solve this myself. I have a Word Document form with Rich Content Control fill-able areas, and a Excel Log used to track those forms. The log has a VBA button to hyperlink the forms based on file name, now I...

I need to collect forms from many departments. I want to give each department 3 weeks to a month to return their forms. I would like calculate 4th Friday from the date I asked them to fill the forms. For example, if I asked them to fill the forms on November 20th, then they should get the forms...

I can manually scroll using the scroll bar. If click out of excel and back into it, then mouse scroll will work. If I open up a userform and close it down, the mouse will then scroll. Upon opening/activating there is no code being executed. No forms are open when opening the document. All...

Hi guys and gals, I want to create a spreadsheet containing cells with fixed characters after every 5 manually entered characters: e.g. xxxxx-xxxxx-xxxxx-xxxxx-xxxxx So basically I want to type all 25 characters but have a "-" after every 5th character. Can anyone possibly assist me in doing this?