1. S

    Tick and cross symbols in same cell based on formula

    In cell A1 I have a formula which comes up with either 0 or a number greater than 0. In cell B1 I want: 1. A tick symbol to appear if A1=0 2. A cross symbol to appear if A1 >0 Not sure how to do it or what formual would allow this as I have never dealt with symbols in formulas? Can this be done?
  2. B

    Userform ListBox - Display a Tick if Condition is Met

    Is it possible in a ListBox that has its row source from a spreadsheet that it can display a symbol like a Tick if the value in the row source was the value "YES" for example ? I have a column that will only have the value YES or No and would like to display a Tick or Cross rather than the...
  3. A

    Checkbox link to a certain sheet

    Hi Guys, Good day. I have a project that i need your help and it goes like this. I will be using a multiple check box and if i tick a checkbox it would automatically go to a certain sheet. Thanks for your advance help.
  4. E

    tick only one checkbox

    Hi there, I am making a userform. I have to checkboxes, checkbox1 and checkbox2. I want to make it such that user can only check one of them at tiime. And I also want to make it as mandatory question for the user such that he or she needs to tick one of the checkboxes! thanks for your help
  5. B

    Question about x axis on graphs

    I have a graph that I want to go from 0 to 80000 in 10000 unit increments on my x axis. I want my data to fall not on the major tick marks (ie: a 25000, 45000, etc). How do I set this up?
  6. M

    Move text in cells via Checkbox tick

    Hi I can anyone help please i have 2 worksheet, worksheet 1 has all patients names in column A2 - A22 and address in B2 -B22. In column C I have a checkbox alongside each name/address. What I want to do is tick the checkbox and the name and address of the person on that row will move to...
  7. T

    Tick macro

    Hi Everyone, I have the macro below which I use to treat my own tick boxes in cells "a" = tick It works great except you have to click away before it will change again. I was woundering if there was a bettter way i could do this? Basickly I want a macro that gives me an "a" in the cell i click...
  8. M

    if statement for +/- a percentage

    Hello, I'm trying to display a tick or cross in F if a variance (D-C) is less than or greater than C but i'm having a total mind blank. Should be easy but its not! I've got the wingdings side easily just the formula is stuffing me around So Num1 ...Num2 ...Variance.....Mark...
  9. F

    VBA to insert rows depending on check boxes in userform

    Good Day Could anyone please help with me with a simple bit of code required to add the details of a userform to the bottom of a list The userform looks like this --> https://drive.google.com/file/d/1q762SqtZkq6knLa9uChjxCy-9PxuUcop/view?usp=sharing The List is located in Column KD. The...
  10. T

    Ideas on how to make a big tick apear in a cell when i click on it?

    Hi Everyone, I'm open to ideas here but I very stuck. Well have a Sheet that has a range in it that I made look like a big Graph of squares, It Range is G15:Z45 Each cell is about 3 cm square so nice and big, I want to be able to click on a cell and have it make a Tick appear or Disappear and...
  11. R

    Excel 2007 Won't Allow Major and Minor Chart Gridlines

    It seems like whenever I add major gridlines to a chart in Excel 2007, the minor gridlines turn into tick marks. And whenever I add minor gridlines, the major gridlines turn into tick marks. I've even tried clicking "Major and Minor Gridlines" in the chart layout menu. But all this does is give...
  12. A

    Searching a cell for unique values

    I'm using the following formula =IF(ISNUMBER(SEARCH("1a.",,$AK2)), "Yes", "No") To search with a cell for 1a. The problem is I get a Yes in cells with 11a. or 111a. What is the tick to find 1a. and 11a. and 111a. distinctly? Thank you!
  13. C

    Gaps between bar sets in graph

    Hi, I'm looking for a way to seperate sets of bars in a graph. I've been inserting a gap by inserting a column between the data, which isn't ideal. Is there a 'proper' way to do it? A tick box or something?!?! Thanks!
  14. John Caines

    tick or cross con.format from list? Is it do/able?

    Hello All. I have been on this for hrs, completely done my head in,, any advise greatly apreciated. I have a sheet with column H & I I want to be able to show a tick or a cross in, if the assigned list shows either a YES or a NO. I just cant get it to work. (I did originally try windings, I just...
  15. P

    Finding a value based on row position

    Hello All A bit of a long shot this one and I've tried so many things to get it working including MATCH, VLOOKUP, INDEX and a combination of all of them however I simply can't get what I am attempting to work and just wondered if it is even possible. I have a worksheet set up with as below -...
  16. John Caines

    Insert a formated tick-cross into cell-vba

    Hello All. I have a spreadsheet with about 450 cells that need to have a tick or a cross inserted into them. I've found a great bit of code here; https://www.extendoffice.com/documents/excel/4558-excel-tick-and-cross.html which is 80% of what I would really like the vba to do,,, code so far...
  17. N

    Remove SOME tick marks from: (a) column graph & (b) x y scatter

    Hi all, I'm trying to create two graphs. One is a column graph. The other is an x y scatter. But I have the same problem for both. I need to remove the first and the last tick marks on the x axis and their labels. Note that the tick marks must be located outside the axis (not inside). I'm not...
  18. M

    Add a symbol to a user form

    Is it possible to show a tick mark on a user form? I want to show the user then the entry made is either valid or invalid with either a tick or a cross. TIA
  19. M

    Interactive .pdf - Complete via VBA

    I have a .pdf from that requires the user to tick boxes, fill in text boxes, etc. I was going to recreate this .pdf form in an Excel sheet but I was wondering if VBA can tel the .pdf what boxes to tick, text to enter, etc from selections made via a worksheet? TIA
  20. S

    Create a scoring system using a tick box

    Is it possible to have a tick box (or alternative?) in a cell so when it is ticked it scores a number specific to that cell in an overall score. For example, if I have questions in column A and then 3 answers in column B, C and D that are tick boxes (i.e. with heading above them bei9ng Yes...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back