button click

  1. A

    Personal Schedule and Summary Log

    I have been working on this personal schedule to plan out some technicians daily work plan for the next two weeks. I am having trouble after inputting some data and sorting it in chronological order by dates and to keep the dates matching with the tasks, equipment, assets, location, and notes...
  2. M

    Dynamic hyperlink tied to a button in Excel

    I want a concat'd hyperlink tied to a button, that when clicked, goes to a website, which would be the dynamic input of what the user entered into a cell added to the end of a static website address I have in another cell. I'm using this function to search a website that puts the user input at...
  3. S

    Advanced: VBA - Click button on Website, copy output from CSV and Paste Contents to Excel

    I am a novice in vba and am starting to learn a few things, but i'm stumped on how to do the following: Essentially, I have a workbook that contains a list of stocks (range a8 to a200) on a worksheet called "summary". Each stock in the list has its own worksheet and I want to download financial...
  4. K

    Paste Multiple Ranges to Different Sheets With Single Button Click

    I'm trying to set up a single button that copies various ranges and puts them into different sheets in the first open row. The purpose is to have those copied ranges automatically graph as more rows are added (this part isn't perfect but I'm content with it). There are 5 groups of ranges that...
  5. N

    Disable button until save

    Good morning, I am using a button to move end of day balances to beginning of day and clear out data. If the button is clicked twice it will move 0's to the beginning balances. I am trying to prevent this from happening. I want the button to only be clicked once until the file has been saved...
  6. P

    Programatically change VBA code in a Button

    I have a button called, btnTestCode. In the VBE, it is listed as Private Sub btnTestCode_Click(). I would like to replace all the contents in it to other code. Microsoft Visual Basic For Applications Extensibility 5.3 is already referenced. I have never done this before and have no idea how...
  7. C

    Cancel Button is not clickable when macro is running

    I create macros to find and replace texts in word documents. Consider the number of documents, I add a Cancel button to let the user to cancel the loop anytime. But the problem is, once the loop is started (start button is clicked) then Cancel button is then no longer clickable. How to keep the...
  8. T

    Macro won't copy data across worksheets

    Hello, I have been looking for an answer and I realise all that numerous types of script can be written for each action. I am producing a guestlist for a large event in which people across a network can access and then enter their details. If someone can help me with the script then I would...
  9. RJSIGKITS

    Adding a fixed date after clicking a VBA button

    Hey guys. I have a sheet which is a new customer data sheet for capturing new client leads. It has a button control (named 'Save Client') to save the document which has all sorts of VBA code attached to it to create directories etc for the new client, and I need the sheet to record the date...
  10. C

    How to click a button when scraping web page using VBA

    Hi there, I am trying to scrape a web page, I could read most of the data present at current page for all years (Mar 16, Mar 15, Mar 14, Mar 13, Mar 12). I want to read data for Previous years also for which I need to click button "Previous Years" on the web page. I would like to get help on...
  11. K

    VBA display message box with values from sheet range

    Hi, Sheet1 has a button that when clicked shows a message box. I would like to show in the message box values from sheet2 withing range A1:A4. This should be in a format of list with lines ... line 1 = cell A1 line 2 = cell A2 . . This range has dynamic values and sometimes some cells are...
  12. J

    Yahoo Search Button Click/Submit

    The following code works well to click a search button, so long as the element has an assigned tag name. Unfortunately I am not able to locate a name element for the Search button on the Yahoo home page. Can someone PLEASE advise on how to successfully re-write the code shown below to click...
  13. P

    Button Click

    Hi All, I have a Button Click of which populates a date into cell D3, listed below. Sub AddDateStamp() Application.EnableEvents = False Sheet1.Range("D3") = Format(Now(), "mm-dd") Application.EnableEvents =...
  14. M

    VBA to copy and Clear

    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...
  15. T

    Button to add rows to different sheets & use formulas from row above

    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...
  16. P

    Using a button to select all check boxes (with a wrinkle)

    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...
  17. A

    Help on VBA to open specific file from the given location

    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...
  18. S

    Delete Column if entire column is empty

    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...
  19. J

    Round Robin Triggered by Button Click

    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...
  20. A

    Excel Vba click Apply button in Career Builder to Apply for JOn

    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...

Some videos you may like

This Week's Hot Topics

Top