Create Button To Do Certain Functions
Feb 13, 2013
I have this request excel sheet which needs a button to do multi functions:
First the sheet is placed in remote server and had two working sheets (say sheet 1 and sheet two), in sheet one there are fields must be filled by the user and a sequence number must be issued for each request.
1- when the button clicked the request serial number must be added by one (counter).
2- log the new serial number, user name and datetime in sheet 2.
3-save the sheet on local pc
4- disable the button after click so that the user could not click the button twice for one request.
View 1 Replies
ADVERTISEMENT
Feb 11, 2010
I have a column ("R") which contains prices. What I'm looking to do is have a form control button that either hides that column, or better still just turn the font white (invisible)on the press of the button, then with another press turn the font back to black (visible) or do I require 2 buttons to carry out this function. I don't wish to have the column formatted in anyway after the changes, simply 1 press turns the font white and either another press (or another button) turns the column back to the exact same state (no formulas present) as it was.
View 10 Replies
View Related
Mar 21, 2007
I am trying to create a custom button in Excel that will sort on two different columns. One column has $ Sales and the other has Unit Sales. So you can click on the button and it will sort by $ Sales and if you click the same button again it would sort by the unit sales. I'd also like the text on the button to reflect what option the data would be currently sorted by. I am able to do one of these macros and assign it to the button, but can't figure out how to get both sort options assigned to the same button. I have had outside people send spreadsheets to me with this but can't figure out how they did it.
View 2 Replies
View Related
Mar 9, 2013
i want to create a save button in sheet 1, on clicking the same the data entered in the particluar cells of sheet 1 should get saved in sheet 2 in given format
View 1 Replies
View Related
Jan 14, 2009
So I've got Sheet 1 with say
____A___B___C
1___m___i___c
2___r___o___s
3___o___f___t
I would like to create a button that can create a new sheet and paste A1 to C3 at the same location on the new sheet
and I need this to create a new sheet and do that everytime the button is pressed.....
View 11 Replies
View Related
Apr 1, 2009
I've got a data set (words and text) where in column J the number 100 appears at random intervals. Each time the number 100appears, i want to take all data from cell A:J and copy that data to a new worksheet and then name it with the word in cell A.
View 7 Replies
View Related
Jun 17, 2013
I have a mental block when it comes to writing functions.
In a cell I have the Post Code followed by a "#" sign (no speech marks) and sometimes more text
e.g. FY6 8JF#ABCD (where the Post Code is FY6 8JF)
The "#" sign always indicates where the Post Code ends, i.e. I want to return all the characters to the left of the "#" sign.
In a spreadsheet I would accomplish this with "=LEFT(AA14,FIND("#",AA14,1)-1)"
where the string of interest is in cell "AA14"
How do I write a UDF to do this?
View 5 Replies
View Related
Nov 18, 2009
I'm trying to use IF and AND functions to create a basic input-output system. The problem I have (more details below) is the 64 limit when the potential inputs could be infinite.
For values entered into a cell between 1 and 10, this should produce an output of 0.00 in another A value higher than 10 should output as 1.00, and from then an extra 1.00 is added for every '10' added. There is no limit on the input ie 1 = 0.00, 11 = 1.00, 29 = 2.00 and so on.
View 2 Replies
View Related
Dec 23, 2013
I have an excel file with a large amount of employee data in it and want to create a search facility that will run on variable search functions and display the information on the screen
I want to be able to enter variable search functions as follows:
Employee Number; shows all information on employee
Division: shows all employees in division (possible from a list of all divisions)
Appraisal Eligibility : Applicable shows all the applicable employees
Job Role: shows all the employees with the same job role (possibly from a drop-list of all roles)
I know its easier in Access, but all records in Excel as a legacy and don't have time to create an access database currently.
View 1 Replies
View Related
Oct 29, 2008
I have a userform, with a save button.
The Save button transfers data from my userform to a worksheet via variables.
It then proceeds to use the variables to generate further data, dependant on a combination of the variables, as this process creates a row of data on the first available empty row, as this script is being used in a loop, ie add another record yes or no.
I need to incorporate a method whereby the user at any point can click on cell S(x) where (x) corresponds to the row clicked, which will then run a macro which will allow me to change a value from OPEN to CLOSED and also add a userentered date into a field called DATECLOSED, it is imperative that this process only work on the row in question.
View 9 Replies
View Related
Jul 26, 2008
creating a button (using VBA code) in a excel worksheet that can initiate a range of output data in a col (say (C1:C100)) by activating the therein formula of each cell (same as what F2 does) and then entering the cell.
Actually I have to do manually each time for each output cell after opening the worksheet that I don't want.
View 9 Replies
View Related
Dec 28, 2011
I have the following code:
Code:
Sub AddFormsButton()
Dim sShape As Shape
With Range("J1")
Set sShape = Sheets("Exposure Country").Shapes.AddFormControl _
(Type:=xlButtonControl, Left:=.Left, Top:=.Top, Width:=96, Height:=20)
End With
[Code]...
Which is called within another macro and inserts a button onto sheet Exposure Country, after which the macro it was called from then stops (i.e. End Sub)
What I would like is that when the user clicks on this button it selects another sheet but I'm not sure how to achieve this.
View 5 Replies
View Related
Jul 4, 2013
i want to create a button sheet. I want when i pressed button a password popup appear n aftr enter correct password rows will unhide.. find out the solution.
View 4 Replies
View Related
Mar 21, 2008
Is it possible to create a button in or out of a cell and when that is clicked it will generate a new sheet in the same workbook.
Now this is throwing the line to you clever people... Having then created a new sheet can it be that in say A:1 it will display the date the sheet was created AND make a popup box appear to allow the user to enter a name for the new sheet?
View 9 Replies
View Related
Jan 15, 2009
I'd like to create a button that makes the "Find and Replace" popup come up when pressed. How to do this? (Ctrl + F is the shortcut for it)
View 3 Replies
View Related
Sep 3, 2009
I'm just finishing a project that is a collection of three calculators, each of which returns data based on a series of user-supplied variables. All the mechanics are working [thanks in part to replies to previous posts], but there is one more thing I'd like to add:
Does anyone have a way to clear the contents of another cell [actually several] cells via another cell? As the most complex calculator requires eight variables to be entered, I'd like to provide a quick way [a button?] to "clear" or "reset" the calculator - basically wipe all unlocked cells. I should note that all of the cells in question already have Data Validation of one type or another.
View 10 Replies
View Related
Jan 10, 2008
I thought I solved it, but it was on a different workbook. I am not in pagebreak preview and it's not password protected. Why can't I insert an object to create to assign my macro?
View 10 Replies
View Related
Mar 17, 2009
Is it true that I have to enable macro and choose to trust access to the VBA project object model in order to create and run macros? It seems there is some security risk associated with making the workbook as macro enabled. What makes the commands run from the ribbon security free? Is it true that we can work around the macro security concern by creating a command button to the ribbon and run the macro from the command button? If yes, how come I could not find any discussion of creating the command buttons? I am using Excel 2007.
View 3 Replies
View Related
Oct 7, 2009
I have 2 tabs on my spreadsheet. The first has some text at the top in cells A1 and A2, and that's it. The second tab I need a script for. Basically, I need some sort of macro button and a text box. I want people to be able to type some text in a cell or box on the 2nd tab, hit a button, and the text that has just been typed will be copied and pasted in to the next available cell down on the first tab.
For example, say the 1st tab had 'title' written in cell A1, and 'hello' written in cell A2. If I were to go to the 2nd tab, type 'bonjour' in to a cell or text box, and hit a button, the text 'bonjour' would be copied, the script would read the 1st tab and see that cells A1 and A2 already had text in them, and so paste 'bonjour' in to cell A3.
View 2 Replies
View Related
Aug 30, 2012
Anyway if its possible...i need to create a button in my worksheet, such that when one clicks it, it'll compose an email thru Outlook; outputting a specific range as the body of the email.
How do i do this?
View 3 Replies
View Related
Sep 13, 2012
I am using the developer tools and have created a set of radio buttons that work fine.
On the same worksheet and tab I have created a second set of radio buttons but all the radio buttons are grouped as the same set.
How do I define the second group as a second group?
View 2 Replies
View Related
Nov 11, 2012
All, I am trying to generate a print button that prints a specific range without using macros. Is it possible? Currently I am using Follow Hyperlink Sheet Event to print the desired range, this works fine but I want to completely lose the macros in spread sheet.
View 2 Replies
View Related
May 29, 2013
I want to write a macro , which creates a form and once the user double click the form i get a popup message "hello" , but when i run my code i get compile error : Sub or function not defined for the line Sub one().
This is the code on my module:
Sub one()
CommandButton1_Click
End Sub
And this is the code i get when i double click the button
Private Sub CommandButton1_Click()
msg "hello"
End Sub
View 1 Replies
View Related
Oct 17, 2008
I have 1 sheet where in sheet 2 i have two type data and that is 1 level service data and 2 level service data. In sheet 1 i wanted 2 buttons that is 1 level service button and 2 level service button. and i wanted that if i will click on 1 level service button it iwll give me the 1 level service data from sheet 2.
View 9 Replies
View Related
Jan 24, 2009
I have a workbook that has a userform with some simple code to translate formulas from .FormulaLocal to .Formula, and back.
I use that workbook a lot to translate formulas I find on here to something my German XL2007 will understand. I thought it would be neat, as well as giving me the opportunity to learn something new, to have that functionality as an add-in, rather than having the workbook open all the time. It is easy enough to save the wb as an add-in, and I can see it in my add-in list, install or un-install it. What i can't figure out is how to put a button on the xl07 ribbon when the add in is installed so i can access it.
View 9 Replies
View Related
Jan 17, 2007
on a workbook I use.
The workbook (26-11GL.xls) contains a varying number of sheets.
Sheet 1 - Menu
Sheet 2 - DS1
Sheet 3 -DS2
Sheet 4 -DS3
Sheet 5 - DS4
Sheet 6 - Company1
Sheet 7 - Company2
Sheet 8 - Company3
Sheet 9 ....14 Company 4,5 etc
Sheet 15 - CompanyTotals
What I would like to do is when I open the workbook on the Menu page I would like to have some links / buttons that will automatically create a new worksheet called DS5 which has all the formatting, formulas etc from DS4 (or the last complete DS sheet)
If this is possible I would like to be able to add Company worksheets as both DS sheets and company sheets can have from 3 to 35 sheets in either area.
If possible I would like the new DS sheets to be named with the next valid number.
View 6 Replies
View Related
Aug 7, 2013
I have five worksheets among eight total in my workbook that I use as a report. I would like to have a button that copies those five particular worksheets into a new workbook and pastes all numbers as un-linked values. This would save me a TREMENDOUS amount of time generating my reports every month.
View 3 Replies
View Related
Sep 4, 2009
I wish to create a button which will allow the user to goto the page in my spreadsheet.
I no i can use macros or hyperlinks to do but i can only use this button once for it to work. I want to cut and paste the button to save time.
View 10 Replies
View Related
Dec 5, 2012
I have an excel that has Marco being run by using a command button to create my pdf's. But my work sheets are Protected by a password. Is there a code for me to insert in order for the worksheet become unprotected for it to do the commands I am requesting?
View 5 Replies
View Related
Apr 16, 2014
I have a table of data which contains company names, the number of high risk policies, number of low risk policies, and the percentage of high risk policies (compared to total policies).
What I want to do is for people to be able to select up to six of these companies and press a button that says 'create graph' and it creates a graph which shows the number of high risk and low risk in a stacked bar, and the percentage on a separate axis as a line. I know how to manually create this graph no problem, but to be able to dynamically create one from selected companies would be awesome.
To start with I have created six drop downs where you can select the company name as I image the macro will need to know which companies' data to look for in the source table.
View 3 Replies
View Related
