button click

Happy Friday everyone :) I need some help with a little project I'm working on and need some VBA code to maximize the document. Here is what i need. 1. once the form is completed i have created a summary cell with Key info that has been CONCATENATED, These can be found in cells A58:A90. Each...

I have a feeling I've over my head, and I may just have to back down from this idea -- more because my knowledge of VBA is limited... but I know how to generally read the code. My Set up: I have a 6 tabbed Book: Info, Main, Inventory, Images, No of Images, Manu Info The connections: Main uses...

I have seen a few tutorials that show how to select all check boxes by selecting a single check box, but I am trying to perform this action by clicking a button and am struggling to adapt the instructions. Also, I would like to perform this action only on check boxes where the related row is not...

Hi All, Please let me know if below is possible in VBA code. I have provided the macro below and few edits(if possible) are required in it. So the first step of the VBA is to open the provided code file. What I need is – - I need one button in the excel file, so when I click on this button...

I have a spreadsheet without 40 columns and 100 rows where information is imported from a Microsoft Access file each day. Depending on the day certain columns are completely empty while others are filled. I have created a button on my spreadsheet and would like to link a macro to that button...

What I need: a cell that populates the next name from a list whenever a macro button is clicked. When the list is exhausted, it should restart with the first name. I'm essentially looking to route leads evenly by creating a Google Sheet that provides the lead router with the next name on the...

I am trying to create code that will navigate careerbuilder with internet explorer and apply for jobs automatically. I am stuck at Applying for the actual job by clicking the button which is input type. The code is below. Also I need to attach my resume which exist on my pc to career builder...

Hello! I have a database for years from 2005-2020 with value. I created an Userform with check boxes. 15 check boxes each one is a year date. (This is my starting point) What I need if possible If I tick 2007,2008,2015,2019 for example I would like that when I press a "Ok" button in the...

hi everyone ! i need help on the codes that can be used for the project im doing now :( im new to excel and im tasked for this challenging project. i sucks at it so please help :( for example : i have 2 tables. table A and table B table A stores the years, category ( apple or orange) , the...

Hi, got this code to increase value by one (same position, row and column, of the active cell) in a second spreadsheet ("foglio2")... Sheets("foglio2").Cells(ActiveCell.Row, ActiveCell.Column) = ActiveCell.Value + 1 but it doesn't work cause it only count 1 in the second spreasheet, doesn't...

I have a user form with 3 questions. 1.) Thickness (this selects the correct sheet I have e.g "6-8mm", "10-12mm"). 2.) Number of defects. From question 1, this number here is inputed into the correct work sheet. 3.) Number of people. Same as questions 2; this number here is inputed into the...

I basically have a lookup form/sheet. You enter a ZIP Code in the designated cell then click a "go" button and it gives a bunch of info from the ZIP entered. (Sidenote that may or may not matter: the entire sheet is Protected except for the 1 cell to enter a ZIP Code) My issue is that after...

Hello and thank you in advance if anyone can help me. I am trying to create a Button Click to open up a Text Box that can be Edited. And then I would like that Text Box to be placed on the active sheet. Nothing fancy. The goal is to have a place where employees that are viewing the page can see...

Hello, I'm trying to automate the process of creating new sheets every time we have a new project. What I'm envisioning is a macro button that will pop up a box that, when filled, will be the name for the new sheet. The sheet would include a standard list of project phases, steps, and...

Hi to whomever could help me, I am trying to create a Recognition progam in excel for my employees, and make it user friendly for others. I have created one sheet (Data) that has all the information stored Names and what we are recognizing them for. Then I have the User friendly sheet (YYD)...

Hi All -- Merry XMAS and Happy New Year! I am hoping that a VBA guru can help with this ..... I have tried for several days to find the VBA code for Excel 2010 that could be used in a macro to capture the button push on a standard Office ribbon button and then execute the macro. Maybe I'm...

I am trying to create a form for my company where requests are filled out for purchases. When they have filled in the required information I would like a button for them to press that would save the form in a specific folder on the shared drive. I do not want any new requests saving and over...

I need a macro that when a button is clicked, after selecting an active cell in A:, the current date will be put into the same row, column AM.This date will be a time stamp so it shouldn't change when the file is opened the following day.

Hi, I am looking to click a button on this webpage Geology of Britain viewer | British Geological Survey (BGS), specifically the one labelled Go To Location (RHS). I cant figure out what its reference is when I look at the source code. My VBA is below, which doesn't work...Sub Geol() Dim sht...

Hello Everyone I have been scouring the web and can't find a solution that works. Here is the website that I am accessing: RT & TMS Outrigger Pad Load Calculator I want to click the "Accept" button. My code successfully opens IE and navigates to the page but then fails to click the button...