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.
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 RelatedI am a new user which I am trying to post a question but when I try posting it, it just goes to a blank page.
View 11 Replies View RelatedOn a user form I have added a multipage Object. It has 5 pages. How can I have each page caption read "Name" Comments where "name" is pulled from a worksheet field (say Questions!C2).
So the Caption needs to pull from a field and be concatenated with the word "Comments"
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.....
how do i print on a3 paper? i can't find the option anywhere...i can select user define size but then where do i define it?!? i know this is a silly questions
View 3 Replies View RelatedIs it possible to have an "if then" statement that would send the user to another page in the workbook? For instance..... =IF(D12="Mobile","Sheet2!","Sheet3!"). I know this does not work but is there another function that would do it? I am very new to vba and am sure it is easy there but I do not have a good handle on it yet.
View 5 Replies View RelatedIndicate that a user-defined function can only be based upon the calculations that can be placed in a single cell. If you have too many calculations to put them into a single cell, e.g., an entire page of calculations based upon a few starting parameters that eventually yield a single value, then how do you reuse this entire page of calculations?
Is there another Excel mechanism that allows an entire page of calculations to used as a stored procedure?
I have a sheet that I would like to print to one page (11x17, landscape) and have it take up the majority of the page. The largest the sheet will ever be is data in rows 1 - 71, and columns A - AC. Right now I have it set up so that when i click on the button, the print dialog opens up and no adjustments are needed to print to pdf in 11x17 for the maximum amount of data.
Overall what I am trying to do is have the zoom change when rows are deleted (columns will always be A-AC). The top 5 rows and bottom 5 rows will always be there. I want the top and bottom margins to be the same on the pdf even if 10 rows are deleted in between.
How can I take the main data sheet and have the information transfer to another sheet? It will be transferring to a "condensed" version with limited columns and when I open the condensed version a like pops open. Then asking if I would like to update this workbook that is contains links to other data sources.
View 1 Replies View RelatedI am new to excel macro. Want to invoke a page and click on submit button. Getting "Object doesnt support this property or method" error on the line "Subm.Click"
My code is,
Sub Macro1()
Dim IE As Object
Dim URL As String
Dim Subm As Object
URL = Range("B3")
[Code] .........
VBA Code To Activate/Press Button On Web Page. press a button on web page using VBA
View 4 Replies View RelatedIs it possible to set the default page to open when clicking the file button? In particular, I use the recents feature a lot but never have I looked at the information on the information page. Everytime I click the file button I have to then select recents which is annoying.
View 5 Replies View RelatedI am looking to write a small macro to convert all figures on a page to either EUR or $ at the click of a button
View 5 Replies View RelatedI have a spreadsheet with the following headings:
A
Claims Number
B
Name
C
Scheme
D
Admin
E
Date
I need to create a user form that will "pop up" and ask the administrator to enter the above details.
A - should be created automatically (ie last claim number + 1)
B - user enters manually
C - data retrieved from a list
D - data retrieved from a list
E - date is the date the information is entered
I have the following code that I am using to create conditional page breaks. It works sporadically. It will work on the data I used when i set up the code. It will sometimes work on smaller amounts of data. It will sometimes insert the page breaks but then error out at line: ActiveSheet.HPageBreaks.Add Before:= Cells(row_index + 1, "D"). I do not understand this code entirely as a i am novice VB user. Once I get this code to work, I'd love to imrove it so that the page breaks ends when there is no data in last row or last column.
Sub PageBreak()
Dim lastrow As Long
Dim row_index As Long
lastrow = ActiveSheet.Cells(Rows.Count, "D").End(xlUp).Row
For row_index = lastrow - 1 To 2 Step -1
If Cells(row_index, "D").Value <> "" Then
'insert page breaks ever time value in column D changes
If IsNumeric(Cells(row_index, "D").Value) Then
If Cells(row_index, "D").Value <> Cells(row_index + 1, "D").Value Then
ActiveSheet.HPageBreaks.Add Before:=Cells(row_index + 1, "D")
End If
End If
End If
Next
I have a UserForm with a MultiPage form on it. Page1 is a totals page with 3 TextBoxes. Page 2 and counting are item pages. Each page also has 3 TextBoxes (nutrients for that item).
Purpose is to add all of the values in the first TextBox on pages 2 + and place the total into the first TextBox on page 1. Repeat this for the other two TextBoxes.
The problem is that I have no way of knowing how many pages I will need!
Is there a way to add a new page to the MultiPage and copy all of the formatting and controls from the formerly last page on to it? I would like to do this with an "Add" button.
My query is regarding internet explorer 6 automation via code in VBA (Excel 2003). I'm trying to open a page on clicking a button in main page.
I'm able to open both parent and child pages via VBA, but now want to automate events (like radio btn click etc) in child page.
below is my initial code -
'========
Sub ListLinks()
Dim IeApp As InternetExplorer
Dim sURL As String
Dim IeDoc As Object
Dim i As Long
'Create new instance of IE
Set IeApp = New InternetExplorer
I have a dashboard containing lots of small charts, I want to copy them individually onto new worksheets and make them full page and set-up for print an full page viewing.
View 6 Replies View RelatedWhat i'm looking to do is create a spreadsheet where the first page allows me to input the number of teams in the group.The teams cannot play others in the group except the ones they are paired with. eg. "Enter number of team pairs in set" (in this case 4)
Team 1a vs Team 1b
Team 2a vs Team 2b
Team 3a vs Team 3b
Team 4a vs Team 4b
After number of teams in set is established click a start button on the first tab of the spreadsheet.
this auto generates a new tab with all the possible win/loss combinations of 4 team pairs.
New Picture.jpg
if the number of teams on Tab 1 is changed (say to 6) and the start button is clicked, another new tab is generated with all possible win loss combinations of a 6 team set.
remember 1a vs 1b can only be win or lose and the win lose combinations are for the set of 4 matches ( or more matches if specified on the first tab and clicked).
if you put 7 in for the number of team pairs then it would be win loss combos for 7 pairs of teams.
I am currently pulling information from a database into Excel. In column A is a list of dates that vary depending on how many days I decide to pull. On any given day there are options to which car will be driven and it is random and there are attributes associated with that drive such as below. If the car was not driven the data pull inputs "No Data" or a "0". On any given day up to three cars can be driven but it is still possible that only one will be driven. This is shown in the second table below. I'd like to be able to create an automated summary table such as the first table below. The summary table should be organized by date and show what cars were driven and their attributes. I know this seems simple but in reality I have six different cars and up to 10 attributes for each car and will be pulling months at a time. The only thought I have had is to do a for loop that checks every individual cell but I am not sure how to implement that.
Car
Miles
MPG
Car
Miles
MPG
Car
Miles
MPG
[Code] .....
I want to create an automatic page break at each value change in Column A, and also a page footer that "restarts" at each change in the same column.
For example, I would like a "Page x of y" footer, but I don't want "Page 1 of 3,500", I want "Page 1 of 3", etc...every time that Column A value changes.
When I view a sheet under Page Break Preview, it shows the Page numbers in the centre of the Page. While I am aware that it would not print the page number I was wondering if there is an option to remove/hide the page numbers.
View 3 Replies View RelatedWithin a worksheet, I have several radio buttons, allowing the user to select only one of them. Using VBA, how do I recognize which radio button the user selected?
View 1 Replies View RelatedI have user form which allow user to entry their inputs in required boxes (Like TxtFirstName, TxtLastName etc.)
My form is working but which I want is that users should first fill up txtFirstName Text Box. Otherwise we will not able to do edit his/ her name in the last Name Text Box (TxtLastName).
Is there any way to do that?
I have a spreadsheet that users update which I then want them to perform a number of checks on. At the bottom will be a button for them to click stating "Click here to confirm checks completed". When they click it I want it to put a flag somewhere that I can then use to prevent them from saving if they haven't clicked the button. I know how to do the saving but, but how do I get the button to put a flag somewhere?
View 2 Replies View RelatedI have a file that contains detailed sales information for each sales person. It typically contains over 20k records and the managers find it difficult to look up their sales people.
Currently it is subtotaled for each sales person but there are about 450 sales people across the country and it's not easy to use.
I have seen other Excel files that use buttons and I am wondering if this might be the solution to this issue. In other words, can I create a button where the managers can just click it, key in their sales person's name and get at the records easier? If so, how does that work? How I could make this file more user friendly.
I have a calculator and I am trying to set a macro that will take the cells highlighted copy them to another sheet, change the format to standard( no background color) make the data fit in one page and print it.
this is what I got so far:
Sub Set_Print()
'
' Set_Print Macro
' set printing area and print
[Code]......
I have a userform for inputting information to a spreadsheet using the code below. It works fine however if the user does not select a radio button to select a score its saving the rest without it. How can I ensure the user selects a score,,,, ob10, ob8, ob6, ob4, ob2, obna.
[Code] ......
so I know how to change the color of a command button(right click, properties), but is there a way to change the color to a specific red green blue range? lets say 102 28 02 for example
View 2 Replies View Related