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

Some videos you may like

This Week's Hot Topics