form button

Hi, I am trying to create a 3 sheet document where 'Sheet 1' is a table where columns A to G are filled in then you would click a submit button (or something along those lines) and this would create a new row on 'Sheet 2' 'Sheet 2' is where Columns I-P will be filled in with information and...

Hello there, Need help with a VBA code or a macro for a clickable button. When the button is clicked I would like "the text in the button" to update the days date. Thank you!

Hello all, I am attempting to distribute an entry form in a way that from within the file itself, entrants can click a button and send the current state of their file to me. In cell a2 they type their name In cells B2:B6 they select their choices via a dropdown menu In cell C2 they enter an...

Hi Just wondering, as the title suggests how to write a query that - based on what is entered on a form - dynamically refers to a column heading in a table. So: I have a table called "Required training": <tbody> Training Teacher Admin Senior Management Safeguarding 1 1 1 First Aid 1 0 0...

Hi; First I will like you to excuse me for my English cause it is not my first language. I am trying to add and image in a form so the user can click on a button and browse the computer for the image. I have add the button and a macro for temporarily unlock and lock the form and browsing for...

Hi Guys. I am trying to make a button that saves the current sheet as a PDF within a directory that is created by clicking a button previously. So, on my sheet, I have 2 buttons, the 1st creates a filepath with a name according to a reference on the sheet, and saves the excel document. I now...

Hello there. I am in need of some help. I am fairly new to excel at least the VBA side of the house and I am so confused about this. I have a spreadsheet that I have to refresh daily and go over to monitor the quanties of such items. Now I want to creat a user form to be able to type in the...

I am fairly new to Access and databases and I have been tasked with creating a database for the department I work in. We import records once a week and users need to go through these records to review them and add notes, make updates, etc. I need to add a few options to filter which records...

I apologize in advanced, I am very new to VBA. Is it possible to create a macro (in my personal.xlsb) that actually creates a macro in another workbook? The macro in the personal.xlsb would go into a worksheet in another workbook, create a macro in a module, insert a form control button and...

I want to have macro form button with a code on it that when click the selected cell will be the last non-empty cell on the Column B. Note B1 is non-empty. because that's where I'm keeping the visibility of the button. Also the Column is pre-filled with data(ID No.) thats why i need the code to...

Hello hivemind, This is a hypothetical problem. I am imagining a spreadsheet with the equivalent of an info button in each cell of column A. The idea is the user clicks the button to open a User Form containing additional info about the entitity represented by values on that row. e.g., Row 1...

I am having issues with printing the Form Option Buttons that I created. In Properties, I have the box checked that says to print. However, when I go to print a hard copy or PDF, the buttons have disappeared. I have inserted ActiveX control and Form buttons, with the same result on both.

So lets say i want to have a spin button that scrolls through each month of the year(or drop down button). And each month is the name of each folder.. how do I do that.. How do i select at folder level not at the file level in the folder ..Because after they select folder then i want a form to...

Hi, From my UserForm1 (Active Sheet is Project Definitions), when I make a selection, I would like to add a Form Control Button on my Sheet called "Start". This part works when the selection is made in my UserForm1: Sheets("Start").Buttons.Add(48, 196.5, 192, 19.5).Select The Button is...

Hi, I created several Form Buttons on a sheet in my Workbook. My question is, when the Button is pressed and I enter the macro the Button points too, is there a way in my VB code to determine which Button was pressed i.e., "Button 1", "Button 2", etc? Thanks,

I have been writing Excel over 10 years and I have never had the need to create a form but I have always used a Form Button. Now I need to be able to change the name of a form button and I don't know how to get into the form controls. I know this is a basic question but can someone help me...

I have been doing Excel VBA for over 10 years but I never got into the form section of Excel and I don't even know how to. I have a button and assigned it to a macro and I have used this macro in several places but somehow one of the buttons got renamed. I am told I need to get into the Form...

Hello, I am looking for some code which will return the location of the form button which is being clicked on to activate the macro. I would like to avoid using an active.x button if at all possible. In this way I can use the same macro on a column of buttons to trigger an action based on...