Getting Rid Of Tick Marks

Nov 28, 2008

Some sent me a large spreadsheet with random rows throughout the spreadsheet highlighted in diffierent colors. I have a module that will sort the spread sheet by Color - however it doesn't work on this spreadsheet because - for whatever reason - every cell starts with a tick mark.

I tried to do a replace all - and excel just told me I was crazy.

I even tried going through and manually removing the tick marks - still no luck.

If I export the sheet in to txt and then re-import it I will loose all the highlights...

View 9 Replies


ADVERTISEMENT

Adjust Interval Between Tick Marks In Graph

Feb 6, 2014

It is impossible to adjust the interval between tick marks when displaying an horizontal axis with 2 categories (years and weeks). The following steps do not change the space between the tick marks.

-Select the graph;
-Chart Tools - Lay Out;
-Current selection - Horizontal (Category) Axis;
-Format selection;
-Axis options;
-Interval between tick marks: 4.

How can I change the interval for the tick marks to display a mark after every four weeks? Is this a bug or by design?

View 5 Replies View Related

Plot/Chart Tick/Check Marks

Apr 21, 2008

Is there any way in which I can map the tick mark labels on either the x-axis or the y-axis to different values other than the ones that are being plotted for.

For example, lets say the data is:

1 5
2 6
3 10
4 15
5 8

I want to plot these in a chart but instead of displaying 1,2,3,4,5 on the x-axis, I want to display a different column, say,

5
7
9
11
13

The answer is not as simple as plotting the required x-values with the y-values. I have just used a simplistic example but the thing I am trying to do has dependencies involved so I cannot simply plot the chart with the required column.

View 5 Replies View Related

Restrict Tick Cell Upon Selection To 1 Tick Per Row

Jan 10, 2007

I was reading your Tick Cell Upon Selection article and it works great. I'm just wondering if there is a way to modify it so that they can only select one of the cells in a row.

For example, in this spreadsheet, the cells I have marked for "tick upon selection" are N8-Q8. In this worksheet, though, I only want the user to be able to select one of the four options. Is there a way to format the code so that they either cannot select another cell until they have deselected the first one, or the first one unchecks itself and the new click ticks that cell?

Example: Person selects N8. Person then selects P8. Can it not allow P8 to be selected (and give a warning message) or can it uncheck N8 when P8 is checked?

View 6 Replies View Related

Tick Box In MsgBox

Feb 3, 2007

I have this piece of code that shows a popup box when the excel spreadsheet loads up.

Private Sub Workbook_Open()
MsgBox "This spreadsheet can design both single-leaf and cavity walls." _
& Chr(13) & Chr(13) & "If only a single-leaf wall is to be designed:" _
& Chr(13) & "Deselect the cavity wall option and complete only the outer leaf input sheet." _
& Chr(13) & Chr(13) & "If a cavity wall is to be designed:" _
& Chr(13) & "Select the cavity wall option and complete both input sheets." _
& Chr(13) & Chr(13) & "All designs satisfy criteria within BS:5628-1:1992 Structural Use Of Unreinforced Masonry", , _
"Spreadsheet Information"
End Sub

Is it possible to place a tick box in the message box that says, "show this message again on startup", then if the user unticks the box the message is not shown again and if the box is left ticked the box will load up again on startup of the workbook????

View 7 Replies View Related

Several Tick Boxes With The Same Macro

Jun 2, 2009

I'm creating a form, that will contain 20-30 tickboxes. Each of these tickboxes will refer to a certain row on a seperate sheet. And it will either hide/un-hide depending on if it is tick/un-ticked.

How can I in the macro know which of the tick boxes that was ticked?

View 11 Replies View Related

Using If Function With Tick Boxes

Oct 20, 2009

I have created a Time Sheet for calculating the work hours of employees. There are various criteria which play a role in how work hours and wages earned are calculated (ex. time, over time, LOA, Travel time, stat holidays etc etc.)

In a certain cell I have placed a tick / check box which the user can tick to indicate that that particular day is a statutory holiday. The tick creates a True / False answer in another Linked Cell.

Based on the True / False result I have a formula which, using the IF function with multiple conditions whether the result is True or False, will calculate the hours worked for Regular, Time and Half and Double Time.

The Formula itself works but when I add the condition based on the check box - example: IF(c37=TRUE,...,if(...,if(...,IF(c37=FALSE,...,if(...,if(... and so on, only the TRUE option works. As soon as the check box is "unticked" I get the result "false".

I hope that all makes sense.

If it helps this is my formula... where C37 is the linked cell for the checkbox.

=IF(C37=TRUE,IF(B10<4.1,B11,IF(B10<8.1,4+(B10-B11),IF(B10<12.1,B10-B11+4,IF(B10>12,8,IF(C37=FALSE,IF(B10<8.1,0,IF(B10>8,IF(B10<12.1,B10-B11,4)))))))))

So, when the check box is ticked, the TRUE argument works fine. But when the check box is not ticked I get a "false" result.

View 14 Replies View Related

Dropdown Box Format Tick & X

Feb 15, 2007

Just put condition formatting on a cell that looks up to Windings tick & X
Now with the listing option in condition formatting
you get the option of a dropdown on the cell you are populating.. great but this is still in the worksheets standard font so shows as an O or P not a tick or X.. any way round this?

View 6 Replies View Related

Tick Cell When Selected

Sep 28, 2007

I would like to achieve the affect where if you click on the cell its contents will change. For example, if you click on it once, a checkmark will appear, but if you click on it twice and x and if you click on it a third time a - will be displayed.
I was thinking along the lines of a marco for the spreadsheet, which would run an if loop to check what was currently in the cell then change accordingly. Is there a command that would allow me to do this, or would is there an even easier way? side note how would I even display a checkmark of square root sign, through vba? This is what I have, It was working but now it does nothing and I cant remember what I tinkered with.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False
If Target.Column = 6 Then
If Cells(Target.Row, 6) = "" Or Cells(Target.Row, 6) = "-" Then
Cells(Target.Row, 6).Formula = ""
Application.EnableEvents = True
ElseIf Cells(Target.Row, 6) = "?" Then
Cells(Target.Row, 6).Formula = "x"
Application.EnableEvents = True
Else
Cells(Target.Row, 6).Formula = "-"
Application.EnableEvents = True
End If

End If
Application.EnableEvents = True
End Sub

View 2 Replies View Related

Hash Marks

May 30, 2007

I have my columns set at a certain width, the cells set to Wrap Text, the Row set to Autofit YET sometimes when I add text, the hashmarks show up as if the cell isnt formatted correctly and Excel cant show all the text. I can resize the cell, change the text whatever, nothing changes. The only way I can fix this is to cut the text out, open a separate worksheet, paste the text into a cell and copy the whole cell BACK into the original spreadsheet, then I have to reformat the text, whereupon it behaves as it is supposed to.

I read about a similiar problem and the reply was that a macro might be causing the error. This is not the case here. This doesnt happen with any regularity so it is very difficult to figure out.

View 14 Replies View Related

Check / Tick All Rows With Same Data

Mar 21, 2013

So let's say I have a table like this:

Apple
Banana
Cherry
Banana
Durian

And when I tick one row:

Apple
Banana
Cherry
Banana

Durian

The rest of rows of same values will also be ticked:

Apple
Banana

Cherry
Banana

Durian

I would like to have the macro/VBA for this.

This question was also posted at:

ExcelForum: [URL]...
MrExcel: [URL]....

View 1 Replies View Related

Can't Get Tick Boxes To Effect Pie Chart

Apr 28, 2014

I have set up a spread sheet which uses tick boxes and I have calculated it all up so that the percentage of ticks ticked is displayed in a cell etc. and when I link that data to a bar chart it works perfectly. .e.g as I tick the boxes the bar chart increases

BUT when I try to do the exact same thing with a pie chart it doesn't work.

View 14 Replies View Related

Using Cell As Checkbox (add Tick Mark)

Nov 13, 2008

I need to click on a cell and when I click on it, it should change colour and insert a tick (or other symbol).

View 14 Replies View Related

Multiple Checkboxes To Tick 1 Checkbox

Feb 21, 2009

I have 4 checkboxes: a, b, c, and d. if all three check box a,b, and c is checked, then check box d is checked. if any of a, b, or c is unchecked, then check box d is unchecked.

View 3 Replies View Related

Spreadsheet Setup - Creating Tick Box

Dec 23, 2010

I have set up a spreadsheet but need to add a tick box, I just need to tick it once the item has been completed.

View 6 Replies View Related

Select From A List Of Names Via Tick Box?

Oct 17, 2011

They have 50 members and if 35 of them turn up to the meeting I want to be able to print out a 35 certificates each with a name on it from the people that attended

Almost like a mail merge from the full list of 50 members but only print out for the people that attended >?

I was going to tick or enter a 1 if the person turned up and then have it pull all the names with a 1 next to it ?

View 9 Replies View Related

Web Automation Tick Box In Nested Tables

Apr 16, 2013

My situation so far i have a rather large program in vba that accesses a site (confidential info im afriad will post snippets though) logs in navigates through a rabbit warren of pages using different types div's form's a href's etc and finally get to one page before where i need to extract information from!!

This webpage has one large table then nested tables within for each entry.

For example

PHP Code:

<table><tr><td><table>info....</table></tr></td><tr><td><table>info....
</table></tr></td><tr><td><table>info....</table></tr></td></table> 

I need to find a way to search the data cells within the nested tables find a specific displayed value then if required tick the checkbox (which has dynamically generated id's names etc) in that row then move on to the next table and do the same.

All I need to do is establish that one row has the data value i need and tick the check box that correlates (which is in the same row).

PHP Code:

<table border="0" cellpadding="0" cellspacing="0"> 
<tr class="altline"> <td> <table> <tr>  <td class="col_time" title="16/04/2013">18:30</td>                      
<td class="col_duration">00:51</td>   <td class="col_placetype"></td>     

[Code] ...........

View 4 Replies View Related

Position Of Tick In Column Chart?

Jan 9, 2014

I have 6 column charts that are supposed to be identical. There are 12 pair of columns per chart. Some chart's pair are centered over the tick and some pair are to the right of the tick and I can't figure out how to make them all the same.

View 1 Replies View Related

Place Tick & Cross In Cells

Jul 22, 2009

I am trying to use WINGDING FOnts on some forms. I am not having full success with them. Sometimes they seem to work, other times not at all, and then sometimes if the code is less that 127. I am programically creating the forms from a worksheet.
The code used to create is as follows:

Sub MakeUserForm()
Dim TempForm As Object
Dim NewButton As MSForms.commandbutton
Dim NewLabel As MSForms.Label
Dim NewTextBox As MSForms.TextBox
Dim NewOptionButton As MSForms.OptionButton
Dim NewCheckBox As MSForms.CheckBox
Dim x As Integer
Dim Line As Integer
Dim MyScript(4) As String
Dim BC As String
'This is to stop screen flashing while creating form
Application.VBE.MainWindow.Visible = False
Set TempForm = ThisWorkbook.VBProject.VBComponents.Add(3)
'Create the User Form
With TempForm..............

View 6 Replies View Related

VBA To Untick / Tick Embedded Tickbox

May 18, 2006

I tried recording a macro (Absolutely nothing is recorded as far as the ticking and unticking goes) and searched for code but came up empty. What VBA code would I use to untick such a TickBox (TickBox1, Sheet22)? I'd conversely also like to know what code to use to Re-tick it.

View 4 Replies View Related

Formula To Consolidate Marks

May 22, 2012

I have three worksheets in which the marks are entered.Now i want to consolidate the marks like

1 in sheet1 2 in sheet2 3 in sheet3 now i want to omit the min(1) marks and add/average of remaining two((2+3)/2)*100.

Is there any formula for this!

View 2 Replies View Related

Tick Box On Worksheet To Turn Auto Calculate On/off

Feb 26, 2009

i can place a tick box on a worksheet that will turn auto calc on/off? The same exact as going through the tools menu but for a lazy person?

View 2 Replies View Related

Tick/show The Check Mark On The Checkbox

Mar 18, 2009

I received a spreadsheet form containing some checkboxes that I need to tick. The problem is I dont know how can I tick/show the check mark on the checkbox. everytime I double click it, macro vb screen appears.

View 4 Replies View Related

Recalculate When I Click The Green Tick In The Formula Bar

Nov 26, 2008

I have a named Formula which works but it will only recalculate when I click the green tick in the Formula Bar. How can I get it to work without needing to do that?

View 9 Replies View Related

Select/Tick/Check A Checkbox Via Vba Code

Oct 1, 2006

How do i check a checkbox on an excel worksheet?

View 5 Replies View Related

Automatically Tick Cell If Entered Value Matches

Aug 23, 2007

I have attached a spreadsheet which, when you enter a matching value in the vehicle column, the cell that matches the vehicle name in both instances (column and row) is ticked. Think I am wanting to use a worksheet_calculate function but cannot figure out how to write the appropriate lookup in VBA. I do not want a formula in the cell.

View 9 Replies View Related

Show Tick Or Cross Upon Checking Cell

Jun 2, 2008

i don`t know how to make this in VBA

But please allow me to explain, if I have numbers in Cell F9 I want image to be displayed as (X <---- which it means wrong) on G9 and message to be appear in H9 says only words are allowed. In case, cell value are words; I want it to show image <---- which it means right) and the message to be say correct. And if cell is empty I want it to show image (!) and the cell beside it the message should say (Please Fill up).

I want to apply this to words instead of numbers as well.

View 4 Replies View Related

Function To Convert Marks Into Grade

Nov 15, 2013

I am looking for a function that would convert any mark into a grade. For example in cell B4 I want to enter the total score, cell c4 the score that a student gets and in cell d4 the grade. It is like a grade calculator. I do not want to limit cell b4 the total score cell with a specific total score number. It can be 100, 50, 30 or 10. The moment I enter any total score and the mark that a student actually scored, the grade is given. I attached an excel sheet.

Marks and Grades Calculator.xlsx‎

View 12 Replies View Related

Inserting Quotation Marks Into VBA Code

Jul 7, 2014

I'm trying to get the following formula into a cell using VBA code:

=AverageIf(A2:AXX,"HR",H2:HXX)

But it's being a problem.

This is the current code im trying to use:

[Code] ........

I've tried

[Code] .......

too but that didn't work either.

View 7 Replies View Related

Quotation Marks Causing Error

Aug 17, 2009

The IF formula works if placed in a cell, but Vba doesn't seem to like the Quotation Marks in Rc11="".

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved