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