cell link

Hello All, I need a little help. I am using four combo boxes from the data ribbon Controls-Insert-Forma Controls Combo box (Form Control). All four have a cell link that provides a number based on each selection. So when Select a value on my 1st box, the 2nd combo it is populated based on...

Hey Experts I need your help. I have to create a financial statements for set of years. We know that closing balance of particular year becomes opening balances of next year, so we link the closing balance of last year to opening balance of new year in new sheet. When we are done with creating...

I am Excel lightweight stuck after looking for days to solve a copy problem with command buttons (option button and spinner). I am creating a 25 year model by creating one year's matrix and then copying it onto the same worksheet 25 times. The copy and paste function does not appear to honor the...

Hi, I've got a workbook that has the 12 months of the year & 10 members of a team. Is there any way of filling in one box with a person's name & Excel will apply it to all relevant tabs, hyperlinks, etc? It'll take a long time to fill in all the relevant information for each team, of which...

Dear Xperts: I am a school teacher creating an excel spreadsheet with radio buttons. I have a cell,lets say D3, it has four radio buttons, and a linked cell D4, which gives the result of 1,2,3,4 based on which radio button pressed. The radio buttons are grouped. They are contained in one cell...

Hi all Hoping someone out there can help with something that is probably very simple... but is driving me insane! I've created a survey with 5 "multiple choice" options for each question. I want to use a radio button to selcet one answer for each question. I have linked the five buttons to a...

Hi Is there a way to copy cells that contain form controls so that the references become relative? I have removed the dollar-sign from the cell link field but that doesn't help. The new cells and form controls (spin buttons) get the same reference as the copied form control. Do I really have to...

The challenge is in putting 100 spin boxes in 100 consecutive rows and having them assigned (Cell Link) to their respective rows (C10, C11, C12, ...). Must this be done one at a time? What would be an efficient way to put them in position and assign them?

How do I make this work? I found this code online but it does not work for the section that deals with the exception for <>target.value that should force the pivots to equal (All). Here is the section: If pf.CurrentPage <> Target.Value Then pf.CurrentPage = "(All)" End If If pf2.CurrentPage...