macro button

  1. O

    VBA: create macro button to open file directory and import txt data to excel

    Hi all, ive been searching the web for answers over the weekend but to no avail. i have no knowledge on vba codes so go easy on me. i would need help on the following: 1. when i click the button, it opens file directory C:\desktop\ 2. i will proceed to select .txt or .csv file 3. upon...
  2. A

    Save Excel Workbook to user's desktop in text format

    Hi there, I've an Excel Workbook (SAP Upload File) that has an Export Button, on clicking it I want to ave a copy of that active worksheet to the user's desktop. After running the below code it is showing a compile error 'Expected End with'. If someone could check this out would be awesome...
  3. L

    Need Help with Macro Button to add 1 to cell based on dropdowns (Row/Column)

    I am having trouble with a macro button, that links to two drop-down boxes. My main sheet (YYD), has two drop-down boxes that reference my other sheet (Data). The first drop-down in YYD!F12 selects a row and the second drop-down in YYD!F17 selects the column on my 'Data' Sheet. I just need a...
  4. E

    Create Button That Prompts User To Select Active Cell

    Hello, I have a macro that uses the active cell to sort through data and fill the acceptable data into three new columns. I wanted to see if someone could help me create a button that prompts the user to select the active cell and then runs through my macro code. This would be very helpful in...
  5. O

    Purchase Order System - VBA for new worksheet from template with PO number auto generated

    I am part way through creating a Purchase Order system. I have so far: - One workbook - First worksheet 'Suppliers' is a list of suppliers with all supplier data - Second worksheet 'Template' is the PO template which uses Data Validate to choose supplier details from a drop down list. I want...
  6. C

    Ribbon and Quick Access Buttons not executing macros assigned to them

    Yesterday, I noticed that my custom "Close without Saving" button stopped working. I checked the VBA editor and my Personal workbook was missing and all of my personal macros were gone. I restarted excel, same issue. Rebooted my machine and they re-appeared. Not sure how what happened, but...
  7. M

    Emailing Workbook with macro button - HELP

    I have an excel workbook (2007) that has a macro that will clear the contents of a sheet. I have that macro assigned to a button on that sheet. I also assigned a keyboard shortcut to the macro. it works fine on my machine and when I email it to anyone inside my company. However, when I email...
  8. R

    Can a chart also be a macro button?

    Hi All, I'm using many small charts on a single worksheet to display information to the client. I would like to make this more interactive, ideally with the user being able to click on a chart and be taken to a worksheet containing more detailed data. I think that the question is then...
  9. T

    copy macro and change row

    Hey all, I have a macro button at the end of a row that copys and reorganizeds the cells in that row to another sheet for printing. Is there a way that I can copy this action down one row? I have a large database and would like to copy these buttons and macros to the end of each row.
  10. J

    Help! Macro to delete/cut row based on specific word in column, and paste the first blank row in another worksheet!

    Hi there everyone, I am new with excel and currently using excel 2003 and I have been asked by my manager to create an action item list and would appreciate anyones help! I've searched through the forums and I cannot find anything that will help me! What I need is a macro code/button that...
  11. E

    Macro for updating a cell on a value match

    Hi, I have used excel for real basic stuffs hence very new to macros and such stuffs.. I ll describe my requirement in brief: I have a 'name' field (person entry) and 'count' field (score) in the below format in Worksheet1: Name Count ----- ------ abc 5 def 10 xyz 10 In Worksheet2, I have...
  12. R

    Pasting macro for skipping blank cells

    Hi everyone. I'm having a bit of trouble with a macro I'm using to select certain info. I don't know much about VBA but I copied a couple old macros I previously had and I've modified them to try and suit the application. It didn't work for me though. (failed miserably actually) I'm doing up a...
  13. H

    Assign macro issue

    I'm running a macro on Excel 2003 and assigned it to a toolbar button via the standard "Assign Macro" form. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> This macro, in order to save the results of all the processing and not affect the original...
  14. WERNER SLABBERT

    auto colour on search?`

    Hi all i just wanna know is it possible to have a vb script or macro that will enable me to do a search for say a number where the number will be in column A on sheet 1 and then when the number is found that whole row will be coloured in say yellow or something? i work with these bloody long...
  15. E

    Macro Button

    I have a button on a worksheet that performs a task. I want to be able to prevent the user from clicking the button, i.e. disable the button, until they have completed certain cells on the sheet. Is this possible? Thanks in advance Steve
  16. L

    Custom Ribbon Button and Macros

    I have a macro which I assigned to a custom butoon in Excel 2003. This macro was run by many users in my organization. I would like to duplicate the funcationality in Excel 2007. I have created the xml code to add a custom button to the Ribbon using the CustomUI Editor. This works well. I...
  17. L

    Universal Macro

    I recently got a macro button up and running that can pull all the data I need for one workbook (9 different sheets) and be placed on the first main sheet. I was wondering how/if you can make a button from one workbook that updates all the others (or at least some of them). The post is at this...
  18. M

    Disable button when there is a error

    Greeting, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I have a macro assign to a button. The button is labeled “Done” and the Macro sub is called “Sub Save_Final()”. The button is placed in sheet1 cell J20. When there is an error on the worksheet, I...
  19. H

    CommandButton vs Form Button

    I want to run a macro from a button on the spreadsheet. I see ther are 2 ways to add a button to the sheet - the CommandButton on the Control Toolbox Toolbar and the Button on the Forms Toolbar. Are there any advantages to using a CommandButton or a Form Button?
  20. 5

    Find Name in spreadsheet

    Hi there, I have a worksheet for each employee along the bottom in my workbook. I would like to be taken to this worksheet when the name has been selected by a drop down list <TABLE style="WIDTH: 308pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=410 border=0...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top