tick

Hi all, New to the forum hope you don't mind me asking question without contribution (yet) My college created me a template but its an prototype and I wish to finish it while he is on holiday I'm stuck at a tick box function, where you tick a box it returns a "true" value For example Cell...

Hello all, I'm new to this forum but I have had an issue that I have been trying to find a work around for a while now. I have a drop down with a list of people on our teams initials. I want to develop a way that when people select their initials (any of the ones on the Defined Name) the cell...

Is there any way of moving a Dynamic Chart with tick boxes that control the visable data in to power point and the tick boxes and hard to still work

Hi guys, Stuck on an issue. I'll start with an example to hopefully make it clearer and easier to understand. I receive a CSV file with the following headings [Age, Height, Name, Gender, Location] with 10 records every week. I have an access database which stores all of these in, although...

Hi, I have an excel document where if I enter "a" it turns into a tick. What do I need to enter so the entry show as 'wip' Many thanks for the helps guys Best Regards, josvill

hi I have a table of data with 6 columns columns B, D and F are the choice of subject columns for info only these list the subject names. In columns C E and G i want the user to be able to enter a Tick to select a subject from each column but only one so once a tick is entered into one cell...

Hi, Good Morning! Been trying to browse the web for answers but only macros were available. I wanted to have 3 checkboxes linked to 1 cell. Cell A1 as the result cell. If I tick checkbox 1, A1 = 50 If I tick checkbox 2, A1 = 100 If I tick checkbox 3, A1 = 150 I hope somebody can help me...

Hello, Most of the codes that I use are either obtained by a combination of internet search, a couple of books, or by using the recorder. Hence I realise they may be very clunky, but eventually they work and do the job. Anyway when a cell in a range is selected, the cell colour is yellow and...

I have a spreadsheet set up where the first sheet lists all of the worksheets that the workbook contains. All of the worksheets are hidden. Next to the name of each worksheet is a box that when clicked on makes a tick appear and the tab with the same name appears at the bottom. Users can select...

I want to make an Excel graph of quarterly data where the X axis has four tick marks for each year, and the major tick mark is labelled with the year, but no labels on the other quarterly tick marks.

Hello :) I am putting together a skills matrix that is to be used by other managers across the organization. There are three parts to this: 1) Identify a skill or competency required (sheet 1) 2) Score current staff skill level for each identified competency (sheet 2) 3) following, the...

Hi all ive found a vba somewhere online where double clicking in a cell causes a tick to appear on any cell within a range (in my case I5:M32), but as I would use this VBA on a checklist, I would only want excel to allow one tick per row. If someone ticked I5 and then J5, the original tick in...

Hi excel gurus, I hope all is well, I was wondering if someone could assist me with the following scenario: I have a number of worksheets in my workbook and I have created a userform whereby a user selects the worksheet name via a dropdown and the code runs to find and replace values for that...

I have a horizontal bar chart which tracks two series. On the top of the chart is my axis which goes from 0% to 100% like the table below. below the axis is one bar which moves from 0 - 100% (lets sat row 2 in the below table <tbody> 10 20 30 40 50 60 70 80 90 100 </tbody>...

Hi, I'm using Excel 2013 and constantly working with lists with filter applied: 1. Selecting the filter drop-down arrow to display the filtered entries -> remove the (Select All) tick -> add the tick to the first record below (Select All) -> filter the data (OK button). 2. To show the next...

This sems like a simple question. But i havent found a solution online that fixes my tick mark issue. My cell indicates TC_ ABC_123 but when selecting the cell i see 'TC_ABC_123. When i deleted the ' mark manualy, it returns. Doing a replace ' with "" does not find anything. I tried the...

does anyone have a simple way of adding a check/tick to a cell? i have an order sheet and the products are in a list in column 1A and the sizes of the product is in the first row. i want to be able to tick each one? and total the final ones which i can probably manage, unless adding the...

Hi All, My first post here, I am a bit of a novice at excel and a complete novice at VB and VBA so be patient with me. It seems a relatively simple problem, but I can't seem to find an answer. I am using Excel 2002 on XP with SP3. I have a large spreadsheet that for ease of reading I have...