clicked

Hello All, I believe I know the answer to this already...but any way. I have a hidden tab. I have a cell which links to the hidden tab When I click on the hyperlink to open the hidden tab, it doesn't "show", because it is hidden Question: Is it possible, without VBA, to unhide the tab when it...

If the active page is page3 or page5, then don't say hello when it's clicked. It's giving me a headache. Can someone fix that for me? Private Sub MultiPage1_Click (ByVal Index As Long ) With MultiPage1 Select Case .Value Case 2, 4 : MsgBox "Hello" End Select End With End Sub

Hi I've researched and I can' find what I want the code do: I want a code that will change a button's colour when it's clicked, but when another button is clicked it would change that button's colour and reset the previous ones. I'm not too sure if there is a way to do it without linking to a...

Hi can anyone help? I have a form button that when clicked adds rows of data to sheet1. Is it possible to have this button add the rows with a single click as it does now but if double clicked add some text in cell A1 ie "ABC" without adding the rows at the same time? any help would be...

Hi can anyone help? I have values in cells "E4:K4" sheet1 that change when commandbutton2 is clicked. Cells "E5:K7" sheet1 also have values that change If any values in cells "E5:K7" match values in cells "E4:K4" when the command button is clicked then I want to remove these values from the...

If I've got the coordinates of the location where I want the cursor to go (can't use setfocus), what is the trick to move it to any given x,y coordinates? I've been able to find code to tell me the the cursor's position when it is clicked on a label, but when I'm done I want it to return to...

Hi everyone I have several frames within a form I'd like change the attributes of depending on the click of a button so, I have declared an object in module one Public frametochange As MSForms.Frame in Form1, I have many frames I'd like to change if a button is clicked. in the button...

Hi Yesterday, I inserted a bar chart. I right clicked on any bar in that char and then clicked on "Format Data Series" then Click on Fill icon, but could not find []Vary colors by point!! I am not able to reproduce that issue again! My question do you know under which circumstance that option...

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

This is my first ever post. I have a spreadsheet that has a lot of check boxes in sets of two. When printed it is hard to tell what is checked. I have redone the sheet and replaced the check boxes with empty cells. I also have a VBA code that will enter a check mark when a cell is double...

Hi all, I am creating a file that will be shared between different users. They will be using input form and when button is clicked, it will fill in the next row with data. This all works fine, however i am having difficulties with shared enviroment. Currently the code is first doing the save...

Not sure what changed but when I open up a workbook I now always get a second blank workbook that opens up as well. Also when I click a cell it now acts like I have double clicked it which is a little frustrating. Any ideas why this is happening and how I can fix it? Thank you MM

Hi I wrote the code below then inserted Control Button in my sheet to run the code. When I clicked on the button first time, it did work, right clicked on the sheet and everything was grayed out, can not copy, rename, move etc. so far so good but then when I clicked on the button again to run...

Hello There is some misalignment when calculating in column J when button clicked. Will appreciate if anyone can help me to correct it in code below For the Following representation <tbody> ROWS H I J 1 NAME AMOUNT TOTAL 2 Xxxxx 5000 3 6000 4 4000 15000 =sum(H2:H4) This is...

Hi all, I have looked for an answer to this query for a few days but, I can't seem to find an answer that covers everything. I have a workbook with several sheets, I want all of them to be able to calculate automatically and one to only calculate if it is clicked on. I found a solution that...

Hi, I am trying to inset Developer-->Insert-->Contol Form-->Checkbox, into my excel. I can insert no problem, but I have problem with changing the default text of these control. I right clicked on the Checkbox, then right click-->format control--> Alt text, then I entered the new text there and...

Hey Guys, Don't know if this is possible, but I will ask. I have a spreadsheet with hyperlinks in it and want to have the current date inserted into column B cell when cell in column A is clicked. Suggestions?

Hi there, I have a single select listbox set up as below. ListBox1.ColumnCount = 6 ListBox1.ColumnWidths = "60;150;45;45;45;45" ListBox1.MultiSelect = 0 I populate it with data and then have a check to see if the listbox is clicked (code below). If so I open a separate userform which gives...

Hi, I have a button on my spreadsheet that I want to make toggle a filter in column AP... So when clicked once I want it to filter everything but blanks in that column When it is clicked again I want it to clear that filter for just that column. I'm sure it's pretty straightforward, but I...

Hi Guys I'll try to explain this properly I have a main page that allow people from a drop down to choose a Product, then from a drop down in the next cell an item. I have then added a button. I am wanting this button once clicked to go to a specific location on another sheet based on the 2...