option

My pivot tables have lots of 0.00 values. PivotTable Option formatting only allow one substitution: For empty cell values show: -- Is there an option to include another substitution: For 0.00 values cells show: -- See the example below where Spaces, Enrolled, Available are all Dax...

Hi I can't find any information on how to do this other than through some sort of goal-seek. Ideally I'd like a formula-based solution, if one exists. Basically I need to 'reverse-engineer' the NPV calculation to find the rate. I've illustrated my problem in the image below (I'm trying to find...

I can not insert a cell in some worksheets in a Workbook. When I right click in a cell to insert a cell the only option available it to insert a Row or Column. Create a new worksheet in same workbook and the option to insert a cell is available. (get pop up asking where to move the cells to...

Excel 2106. Setup of Worksheet: Column F (starts from F10), you can choose the option “Closed” and “Cancelled” Wat I want: When the option “closed” or “Cancelled” is selected (example:F10). I want the following information to be filled in: In Column M (M10) the date of today. In Column...

I have 2 option buttons in a frame on a user form. When one of them is clicked (changes), I want to trigger code that makes the visible property of a textbox (which is not in the frame) false, that is, hide the text box. I want to do this without having to click a command button first, through...

Hi All, I want to be able to click on a Supplier in the drop down menu on the PO Tab and all the address details are pulled through onto the cells under the supplier name, I know this is possible but I cant work out how to do this. I do not have an option to upload an example but I can PM one...

We receive updates from our supplier in the format below showing products we have ordered by stock number and the options we have chosen against each product in a // delimited format. So the data looks something like this except there are around 50 available options and typically around a dozen...

Suggestions on how to add code to require Option? UserForm1 includes 2 OptionButtons If neither OptionButton is True Then MsgBox "Option Required" Private Sub CommandButton1_Click() With Sheet11 Sheet11.Unprotect Set ws = Sheet11 PName = UF1.ComboBox1.Value Set CLoc =...

I have entered a data validiation condition in cell A1 with options "Yes" and "No". In cell B2 i want the outcome as follows: On selecting "Yes" option in A1, the value in cell B2 is automatically changed to 100% On selecting "No" option in A1, no change takes place in cell B2 and the user...

Dear, I am using following code but giving some error. If cell value A1 is blank option button is hidden when put any value in A1, it should assign as option button caption same goes till A7 Sub optionbutton() ' ' optionbutton Macro ' Private Sub Worksheet_Change(ByVal Target As Range)...

Dear Sir I just need a way out that option button caption / name should be pick from cell values; Like option button 1 should be linked with Cell A1 accordingly Option Button 7 linked with Cell A7 When we changed values in cell, option button caption may also be changed. Regards

I have some problem in my excel formula. how can i upload excel file in my thread. please help. where is attach file option

I've seen this option on the Format Alignment Dialog box for years (the option underneath the Merge Cells option) but never really used it. It has 3 options: Context, left to right, right to left. How is the cell display impacted when data is being either entered or copied into a cell? Michael

Hi, I am facing some trouble formulating a macro to run upon closure of workbook. I would like to run a macro to check if there are unselected option buttons within my specific sheet. The option buttons grouped in rows of 5 where only 1 can be selected per row and it runs down as long as the...

Hi Everyone, I am attempting to change the background color on my format control button but I do not see an option to do so. Is this only available for the format control text box and option button? Regards, Dastnai

Hi I inserted 4 options control (Developer-->Insert). I liked them to cell K1 1) What is the capital of USA () NY () Whatever () DC () etc When I click on first option, K1 value becomes =1 , if click on second option K1=2 etc Now I want to create a new question and insert new set of option...

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

Morning, On my worksheet in 3 different columns i am seeing them circled as invalid. Column B is a car registration & column J is a code & column L is a chassis number. What i now find is that when i use "Data Validation Circle Invalid Data" i see a message to say that i have more than 255...

Hi there, My question: How do I restrict the user from manually typing the "%" symbol in a cell?? Background: I'm trying to finish a basic user form (with drop-down lists) where: - if option 1 is chosen in cell A1, then cell A2 is formatted in Accounting format. - if option 2 is chosen in...