Using Buttons Over 2 Workbooks...

Aug 5, 2009

I currently have a sheet (SHEET-A) which pulls in a figure from a cell (CELL-G) in another workbook sheet (SHEET-B), and displays the value in CELL-X.

CELL-X then is used for a series of calculations on SHEET-A.

CELL-Y is adjacent to CELL-X and can have a number entered into it which is then used instead of CELL-X for the calculations on SHEET-A. (It is also incidently displayed over CELL-Gs value in CELL-X)

I would like to have a button next to CELL-Y which upon click alters the value of CELL-G in SHEET-B to that of CELL-Y in SHEETA.

View 9 Replies


ADVERTISEMENT

Multiple Macro Buttons (radio Buttons)?

Feb 10, 2012

I am trying to create a worksheet that has multiple radio buttons. Each radio button is linked to a Macro. I need there to be many buttons running down one side of the worksheet. Each button needs to perform a macro that is relevant to the cells in the same row that it is on.

Essentially what i am trying to do is make a macro that when the button is pressed copys data from H6 and paste it into B6. The button is situated above I6. I need a button for each row from 6 to 110.

While this macro is easy to create (i use the record button and then assign the macro to the button), i would have to do this 104 times and assign a new macro to each button.

Is there a quicker way?

View 6 Replies View Related

Change The Color Of Buttons Or Command Buttons

Mar 14, 2007

Is it possible to change the color of buttons or command buttons? There does not seem to be any place that allows this under properties for buttons, although there does for command bars. However, I've tried recording a macro as I change the color, but nothing get's recorded so I'm not sure what the syntax would be.

I have a spreadsheet with several buttons and I'd like them to change colors as they are pressed so it's possible to see what you've already done. And then, as soon as any other cell on the sheet is changed, the buttons reset color.

View 9 Replies View Related

Copy Worksheets From A Couple Of Workbooks To Other Workbooks

Jun 26, 2014

I have 25 files with certain worksheets that I need to move to 25 other files.

Worksheet 1, 2, 3 and 4 in Workbook A needs to be moved to Workbook A-2014 Worksheet 1, 2, 3 and 4 in Workbook B needs to be moved to Workbook B-2014 Worksheet 1, 2, 3 and 4 in Workbook C needs to be moved to Workbook C-2014 etc....

Is there a way to do this with a macro? Preferably I would like to do this automaticly - i.e. runing the macro from a master file that

1. Opens Workbook A copies the worksheets
2. Open Workbook A-2014 paste the sheets
3. Save and close Workbook A-2014
4. Close workbook A without saving

then doing the same for Workbook B, etc.

View 5 Replies View Related

Close Workbooks And Move In And Out Of Workbooks In VBA

Dec 27, 2009

Basically the main workbook opens 2 files at a time performs a calculate in the main workbook and then copies and pastes information in 3 ranges. Then closes the two open workbooks and loops and performs same operations until it hits the maximum loops. My macro is as follows and I have 3 question in capital letters.

View 3 Replies View Related

Radio Buttons.?

Apr 8, 2009

I've got a small problem with radio buttons. I've been asked to add a few to a sheet we use at work, problem I'm having is when I add these new buttons from the forms toolbar and then assign the cell link for them some of the other radio buttons on the sheet asume the cell link of the new buttons and when I change them back the cell link for the new buttons change ? i could understand this problem if I had maybe copied them and modified the copies perhaps but that isn't the case.

View 2 Replies View Related

Creating Buttons Using VBA

Dec 16, 2008

I'm trying to make a macro that creates a button (to run another macro). I'm also trying to make sure this has a specific name, instead of just "Button#". The code I get from recording this is:

View 5 Replies View Related

3 Different Validation Buttons

Mar 31, 2009

my main project will have about 8 different buttons.

View 5 Replies View Related

Filter Using Buttons

May 16, 2009

i want to filter the sheets on click of a button .

like in this sheet i want to filter the column E in column E their are many reasons of non delivry of my products i want to find out which department is accountable for how much loss so on click of a button it filters with 2 reasons

RTM department

1)Ko Cannister stock Out
2) Outlet Need fresh stock

View 7 Replies View Related

Protect Buttons ...

Jan 24, 2010

Dear sirs,with best regards,i have in attached example file some cells i have protected them by ( tools-protect ) which is the general way for protection,for special purpose i ask you kindly to help me by:

creating a buttons with macros to protect and unprotect the ( cells,columns,rows,and all the sheet) that i need to protect them, when i want to (protect or unprotect) i have to click these buttons.

View 6 Replies View Related

Linking Buttons With A Row?

Nov 23, 2011

If possible I would like to create using vba a button at the end of my rows of data allowing a user to copy and insert the row next to the button, i.e. duplicate.

I am using the following code to create the button but am not clear how to link a button to a row or cell. The button would be within a cell in a row at the end of the data.

Range("a2").Offset(rowoffset, 10).Select
ActiveSheet.Buttons.Add ActiveCell.Left, ActiveCell.Top, ActiveCell.Width, ActiveCell.Height

rowoffset increments within a loop and a button is placed at the end of each row of data.

I would also like to know how to name the button.

View 5 Replies View Related

Option Buttons

Aug 23, 2007

I created a frame in a spreadsheet I put in 2 options buttons that I called Left the first one and Right the second one. I got 2 cells lets say C10 and G10 in these 2 cells I write the cell number values. When I click on button one or Left, I need the cell C10 be set focussed and write a number e.j 5. However, when click on the second butt to write a number e.j 7, the number in the cell C10 still there, so, what I need is a cero or an empty cell C10, and viceversa. Could you help to write a code for this problem.

View 9 Replies View Related

Getting Rid Of Command Buttons

Apr 9, 2009

I have a range of cells (A1:D5) identified within a worksheet (worksheetA) as part of a user input form.

When a certain condition exists, a routine is executed that copies a range of cells (C1:F5) from another worksheet (worksheetB) to this defined range. The copied area consists of two command buttons. They get copied and pasted no problem.

When I want to reset (blank it out of its contents) my range in worksheetA from I copy another range over of just a range of blank shaded cells. However, doing this does not eliminate the command buttons left in the range on previous pasting.

How do I delete these command buttons left from previous pasting activities when I wish to reset my range?

View 9 Replies View Related

Sum Up Yes & No Buttons Results

Feb 20, 2009

I am trying to do a small survey within my company by email.

It is very short, 5 questions, I was hoping to add in yes/no buttons and have a code that will sum up the individual responses.

Something like (yes(1,4)=2) (No(2,3,5,)=3 .......

View 9 Replies View Related

Buttons Not Visible

Mar 5, 2007

I have created a great little macro to handle a large amount of data on my spreadsheet that I've been using for several months. It's a shared sheet that is used by many people, but the macro is protected...That being said, something strange has happened that none of my buttons for activating the macro are no longer visible. I can't even create new ones. I get a box outline with a little red X in the upper LH corner. I've verified that the button is in fact set to be visible and set up properly for colors, etc.

I'm not sure what's happened since it happened in a matter of hours...did something get "deactivated" that I need to re-instate?

View 4 Replies View Related

Round Buttons

Mar 27, 2007

Is there a way to put round, or any other shape, buttons in vba forms?

View 6 Replies View Related

Set All Option Buttons To No

Jun 26, 2007

is there a way to set all yes/no option butons to "no" when a worksheet is activated?

View 5 Replies View Related

Hide Cells Using Buttons?

Feb 13, 2014

IMAGE1.jpg ... This list uses rows up to 1040. What I am needing to do is create a master button similar to the "Show All" Button at the top that hides any sub group automatically based on the values in the yellow box. The hide button to the right of the hardware assembly will hide the rows when pressed but that requires me to go down the list and press each button that the yellow box has a zero in. I would like to create a button that has a macro that will automatically "click" or run the hide button when its corresponding yellow box has a zero in it. If the value is greater than zero it does not need to hide that hardware group.

Example from attached image. If I were to run the new macro it would run the hide button for rows 5-8, not run the macro for rows 10-13, then again run the macro for rows 15-18, and so on until it reaches the last yellow box which is row 1036 (hide rows 1035-1039).

View 9 Replies View Related

Linking Buttons And Datasheets

Dec 30, 2008

I'm interested if it is at all possible to configure say, one sheet that is a rough visual layout of an inventory shelf, and if an object on said shelf was clicked, then relevant text would be displayed in the respective fields.

So if I had a picture of a shelf full of groceries on sheet1, and say clicked on a can of beans, then beside my picture of the shelf full of groceries, it will copy over the information I keep relevant to my beans.

View 5 Replies View Related

Automatically Shrinking Buttons

Aug 5, 2009

What can I do to prevent a button to shrink to a fraction of its size when it's clicked?

It used to work alright, but when I got the file back from a collegue it started to show this weird behaviour?

View 9 Replies View Related

Can't Delete Buttons On Top Of Worksheet

Nov 26, 2013

I'm trying to delete the buttons on the top of this worksheet, and for some reason am not able to do so.

View 3 Replies View Related

How Much Memory Do Command Buttons Add

Jan 17, 2014

I have been having an internal debate of how my worksheets shoud be configured.

My workbook could potentially contain 300+ worksheets, 10 control buttons and around 20 macros.

Each worksheet contains data in a range ~ A1:AC40 with many blank cells.

Do you think a workbook with this many worksheets would be unmanageable given the Comp Spec of the user PC below?

Most of the cells are simply short text data.

System info
Processor: 2.3Ghz Dual Processor
RAM: 2GB
32bit

View 7 Replies View Related

How To Unload Option Buttons

Jan 17, 2014

Attached I have kind of a score card, when you open the tab named TEAM1 a userform pops up and I pick the partners that played together, then I can pick an option button labeled 0,1,2 or 3, when it unloads, is it possible to make it put the corresponding number by their names in the empty row (W) of the week they are playing?, and not just the 1st open row available?

For example, if I pick the names Ryan and Stu the number will go under week 10 (X3) and not find the empty cell in (J3)?, I have no clue how to make this happen, but I made a userform to use, to try and make it work.

POOL LEAGUE TEST.xls

View 8 Replies View Related

ActiveX Option Buttons VBA

Mar 19, 2014

I am looking for a way to use 2 optionbuttons in vba. The option buttons are in different groups, and are independent.

I cannot get this to work. Is this even possible? In sheet1, the vba would read something like this.

View 9 Replies View Related

Spreadsheet Model & Buttons

Dec 20, 2006

I want to create a button on this spreadsheet - the button will be called z4 in the "Yr 9 ICT" sheet

it will include the following

rows Jane Bloggs 2
rows Jane Bloggs 12
rows Jane Bloggs 22
rows Jane Bloggs 32
rows Jane Bloggs 33
rows Jane Bloggs 42
rows Jane Bloggs 44
rows Jane Bloggs 66

What do I have to do to create this.

View 10 Replies View Related

UserfForm That Contains A Few Buttons, Textfields Etc

Apr 29, 2008

I have a userfForm that contains a few buttons, textfields etc. And at the workbook, I have a few sheets that shows different data.

1) Is it a must that the userForm need to be in the excel workbook? Can we export the UserForm out?

2) What can I do to make sure that when I click at one of the button at the userForm, a new window would be popped out and show only a specific worksheet in the workbook?

3) Is loop the only method to check a list of record against another list of record? I find that when I used looping the processing time is long.

4) what is the method that I can use so that the cursor will always stay at a particular textfield?

View 9 Replies View Related

Combine Functions Of 3 Buttons Into 1

Dec 16, 2008

In the attached xls I have a button on each tab, ideally I would like the button on the first tab to do everything, but I cannot seem to get it to work hence the current layout.

First button on first tab creates new xls and copies content of 2nd tab onto it, then copies various bits of info from certain cells in tab 2 into the 3rd tab.

2nd button on second tab simply clears the contents of the form, which is no longer needed as a seperate copy has just been created.

3rd button on 3rd tab just tidys up the cell borders

It would be much easier if I could get one button click to do everything (in that order preferably).

View 14 Replies View Related

Hiding Buttons/showing Them

Jan 28, 2009

In my sheet, I've got a command button that protects the sheet and unprotects it (code was thanks to this forum) and I'd like to make it so that when the sheet is protected, all the other command buttons are hidden (CommandButton1 to CommandButton5) and then when the sheet is unprotected again, the buttons all show up.

The reason for this is because when other buttons are clicked as the sheet is protected, it brings up the error and shows Debug as an option and then the user can click that to look at the code and password for the protect sheet button.

View 5 Replies View Related

Command Buttons Not Working

Feb 3, 2009

i try run macro with commandbutton, but it doesnt work. I insert button from "control toolbox" then i create a macro. Then i wrote this macro to "Private Sub" but it still doesnt work.

When i click on button, it only open editing macro, or select the button.

View 6 Replies View Related

Option Buttons And Combo Box

Jun 2, 2009

I use Excel2007 and saved this workbook as excel2003, the combo box doesn't dropdown anymore? I don't understand why....is it just settings? If you could have a look at the code I use for the option buttons...when I select the first optionbutton it calls the msgbox without selecting the offset cells. From optionbutton2 onwards it works fine.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved