buttons

I have a bunch of command buttons in a workbook. I wrote the workbook vba coding on a machine with a 4k display and Excel 16 and the 1st user-machine (Eventually to be 40) are using colder machines with 4:3 screens and excel 2010. Subsequently, the buttons are changing sizes/positions when...

Hi I have a sheet which has different control buttons (developer-->insert) and different macros are assigned to these buttons. I created a macro to move the sheets around. How can keep this sheet active even after moving it do different location (order, for example after sheet2 or 3 or 4 etc). I...

Hi I inserted 4 option buttons in a sheet (developer-->insert). I linked them to cell K1 Now when i click on the first one then K=1, second one, then K=2 etc. So far so good. I wrote this formula in L1 L1 = if (K1=1, N1=1,N1=100) So I want to make the value of cell N1 = 1 if K1 is 1, how can...

Hi I Have A Workbook. In Sheet 1, Column A Contains Order Numbers. In Column B I Have Buttons (1 Per Row). In Sheet 2, Column A Contains The Same Order Numbers (But With Different Info) What I Need To Do Is... If I Click The Button In B24 It Takes Reference Of The Value In A24 Then Goes To...

I have a query relating to sorting in Excel that has me stumped at the moment. I have a table with five Command Buttons in Column A. In the columns B - E is the data. When I select Column A - E and try to sort, on Column C for example, the data sorts as expected but the Command Buttons in...

Hello friends, I'm trying to create a sheet used for project estimation and i want it to be simple to use. I want to be able to use buttons to create/delete tasks (cost item) as well as buttons to indent/outdent a task. The later should function like MSProject works. An indented task is now...

Hello all, I am after some help. I have a database showing a rota, when I highlight cells I want a few buttons to press (On the sheet) so the cells I have highlighted go that colour.

Hey guys Im trying to write somehint which fills in a webform for me from my excel file, I amamanaging to get the data i want into the fields however im struggling to click two buttons as the dont have an ID The first one is: input type="submit" name="terminal_group_search" value="Search"...

Hi i need help. I have create workbook that has a userform. I have users and admin accounts. However with the user accounts they are still able to copy/delete worksheets. Is it possible to make these options only available for my admin accounts? I have looked at protecting the workbooks...

Hello So I have a macro that adds a sheet, formats it, adds the formula, and adds buttons (calling other macros). There are 7 buttons made for each sheet made- so I'd like to know how to hide two of the buttons when the sheet is first made (I presume for the button itself, when it's made I just...

Hi, I wish to delete a photo when the worksheet is closed. My code that runs when i close the sheet is supplied below. I have just run the code and noticed that on the sheet DR PDF it has deleted the command button 1 & 2 The code is still on the sheet but the 2 buttons are gone. HAVING SAID...

Hi I created a form which has 3 text boxes and 4 cmd buttons. user will enter number in the first box and another number in the second box and click on +,-,*, / buttons and the result will be in box 3. The -,*, and / work fine but I noticed the + is not. If user enter 1 in the firstbox and 2...

Hello Trying to figure out how to add a togglebutton via code. I've been adding buttons a few different ways, but the most efficient (to me) seemed this code that I've been using: Sub Buttoner() Dim a As Button Dim w As WorkSheet Set a = w.Buttons.Add(840, 170, 108, 30) a.OnAction = "MyMacro"...

So I have two CMD buttons in a userform that change the the value of a cell. I'd like the cmd button that is clicked to turn green and the other to stay its boring white- and if the other button is pushed, the first to change back to white and the other to go green- essentially letting you know...

Hello, Can someone help me please – I would like to stop peoplefrom closing my spreadsheet with the X buttons in the top corner of the screen.I want them to use a button which when clicked saves and also closes thespreadsheet. I have tried looking on Google but all I can find is code todisable...

Hello Again, I have a macro that creates a new sheet, formats the entire sheet, adds all of the formulas throughout the sheet, and creates a few buttons. These Buttons (Reset Sheet, Print, Save, and Index) aren't complicated, but because I am constantly generating a new sheet, I was...

Have 10 command buttons and a text box. When I enter a value in textbox1 i want to show that number of command buttons E.g if I enter 0, no command buttons will appear, if I enter 4, command buttons 1,2 ,3 and 4 will be visible and the others won't be. Thanks

How can I create a transparent Command Button? I would like to have 50 or so Command Buttons overlaying cells in a worksheet such that the contents of the cells will show through the command button.

Hi all, Im having some intermitant trouble with the followin code (line where i've put the arrow) The code sometimes breaks here and i have to close the spreadsheet and reopen it.. it works fine after that.. until it does it again. Any ideas? :) Thanks, Dan Option Explicit Sub...

Hi Forum, I came across this webpage with some beautiful animated buttons. I have a few buttons in an Excel Workbook that activate some VBA projects, and I was wondering if I could add the buttons I found into that Excel Workbook. I have no knowledge of integrating different languages into VBA...