Hey guys
I have some minor issues on my board:
1) Are there any way to delete the cell value in range A1 when
activating cell/range A2?
- wanted effect is when user activates cell A2 (by click) the value /
content inn cell A1 will be deleted.
2) When constructing coordinates as textstrings (X Y Z) by linking
values from range B1, B2 and B3 ( the text string will not appear whit
decimal format.

#1. Right click sheet tab>view code>insert this. DOUBLE click to fire
#2. More detail?

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Target.Address <> Range("b1").Address Then Exit Sub
Range("a1").ClearContents 'Delete
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"Snoopy" <blaksnm@jjuc.no> wrote in message
news:4b9593d7-b485-47b0-9c85-36000e4d96aa@40g2000prx.googlegroups.com...
> Hey guys
> I have some minor issues on my board:
> 1) Are there any way to delete the cell value in range A1 when
> activating cell/range A2?
> - wanted effect is when user activates cell A2 (by click) the value /
> content inn cell A1 will be deleted.
> 2) When constructing coordinates as textstrings (X Y Z) by linking
> values from range B1, B2 and B3 ( the text string will not appear whit
> decimal format.
>
>

On 15 Okt, 15:08, "Don Guillett" <dguille...@austin.rr.com> wrote:
> #1. Right click sheet tab>view code>insert this. DOUBLE click to fire
> #2. More detail?
>
> Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
> Boolean)
> If Target.Address <> Range("b1").Address Then Exit Sub
> Range("a1").ClearContents 'Delete
> End Sub
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@austin.rr.com"Snoopy" <blak...@jjuc.no> wrote in message
>
> news:4b9593d7-b485-47b0-9c85-36000e4d96aa@40g2000prx.googlegroups.com...
>
>
>
> > Hey guys
> > I have some minor issues on my board:
> > 1) Are there any way to delete the cell value in range A1 when
> > activating cell/range A2?
> > - wanted effect is when user activates cell A2 (by click) the value /
> > content inn cell A1 will be deleted.
> > 2) When constructing coordinates as textstrings (X Y Z) by linking
> > values from range B1, B2 and B3 ( the text string will not appear whit
> > decimal format.– Skjul sitert tekst –
>
> – Vis sitert tekst –

Thanks - that was a quick one! But I still dont get it right :(
Right click on sheet tab and paste the macro - right? What did you
meen by "double click to fire"?
Regards
Snoopy

Read the instructions again.
You said you wanted to click the cell. This requires a DOUBLE click in b1 to
clear a1
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"Snoopy" <blaksnm@jjuc.no> wrote in message
news:84c2e159-9bc7-441c-b345-a70d50180c6f@a19g2000pra.googlegroups.com...
On 15 Okt, 15:08, "Don Guillett" <dguille...@austin.rr.com> wrote:
> #1. Right click sheet tab>view code>insert this. DOUBLE click to fire
> #2. More detail?
>
> Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
> Boolean)
> If Target.Address <> Range("b1").Address Then Exit Sub
> Range("a1").ClearContents 'Delete
> End Sub
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@austin.rr.com"Snoopy" <blak...@jjuc.no> wrote in message
>
> news:4b9593d7-b485-47b0-9c85-36000e4d96aa@40g2000prx.googlegroups.com...
>
>
>
> > Hey guys
> > I have some minor issues on my board:
> > 1) Are there any way to delete the cell value in range A1 when
> > activating cell/range A2?
> > - wanted effect is when user activates cell A2 (by click) the value /
> > content inn cell A1 will be deleted.
> > 2) When constructing coordinates as textstrings (X Y Z) by linking
> > values from range B1, B2 and B3 ( the text string will not appear whit
> > decimal format.– Skjul sitert tekst –
>
> – Vis sitert tekst –

Thanks - that was a quick one! But I still dont get it right :(
Right click on sheet tab and paste the macro - right? What did you
meen by "double click to fire"?
Regards
Snoopy

On 15 Okt, 15:51, "Don Guillett" <dguille...@austin.rr.com> wrote:
> Read the instructions again.
> You said you wanted to click the cell. This requires a DOUBLE click in b1to
> clear a1
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@austin.rr.com"Snoopy" <blak...@jjuc.no> wrote in message
>
> news:84c2e159-9bc7-441c-b345-a70d50180c6f@a19g2000pra.googlegroups.com...
> On 15 Okt, 15:08, "Don Guillett" <dguille...@austin.rr.com> wrote:
>
>
>
>
>
> > #1. Right click sheet tab>view code>insert this. DOUBLE click to fire
> > #2. More detail?
>
> > Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
> > Boolean)
> > If Target.Address <> Range("b1").Address Then Exit Sub
> > Range("a1").ClearContents 'Delete
> > End Sub
>
> > --
> > Don Guillett
> > Microsoft MVP Excel
> > SalesAid Software
> > dguille...@austin.rr.com"Snoopy" <blak...@jjuc.no> wrote in message
>
> >news:4b9593d7-b485-47b0-9c85-36000e4d96aa@40g2000prx.googlegroups.com...
>
> > > Hey guys
> > > I have some minor issues on my board:
> > > 1) Are there any way to delete the cell value in range A1 when
> > > activating cell/range A2?
> > > - wanted effect is when user activates cell A2 (by click) the value /
> > > content inn cell A1 will be deleted.
> > > 2) When constructing coordinates as textstrings (X Y Z) by linking
> > > values from range B1, B2 and B3 ( the text string will not appear whit
> > > decimal format.– Skjul sitert tekst –
>
> > – Vis sitert tekst –
>
> Thanks - that was a quick one! But I still dont get it right :(
> Right click on sheet tab and paste the macro - right? What did you
> meen by "double click to fire"?
> Regards
> Snoopy– Skjul sitert tekst –
>
> – Vis sitert tekst –

Thats nice! :) Thanks
Are the the same posibility to only activate by one click in this?
Regards Snoopy

Fries with that?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"Snoopy" <blaksnm@jjuc.no> wrote in message
news:3488edbd-33ac-4931-8899-8badf6b75d82@t39g2000prh.googlegroups.com...
On 15 Okt, 15:51, "Don Guillett" <dguille...@austin.rr.com> wrote:
> Read the instructions again.
> You said you wanted to click the cell. This requires a DOUBLE click in b1
> to
> clear a1
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@austin.rr.com"Snoopy" <blak...@jjuc.no> wrote in message
>
> news:84c2e159-9bc7-441c-b345-a70d50180c6f@a19g2000pra.googlegroups.com...
> On 15 Okt, 15:08, "Don Guillett" <dguille...@austin.rr.com> wrote:
>
>
>
>
>
> > #1. Right click sheet tab>view code>insert this. DOUBLE click to fire
> > #2. More detail?
>
> > Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
> > Boolean)
> > If Target.Address <> Range("b1").Address Then Exit Sub
> > Range("a1").ClearContents 'Delete
> > End Sub
>
> > --
> > Don Guillett
> > Microsoft MVP Excel
> > SalesAid Software
> > dguille...@austin.rr.com"Snoopy" <blak...@jjuc.no> wrote in message
>
> >news:4b9593d7-b485-47b0-9c85-36000e4d96aa@40g2000prx.googlegroups.com...
>
> > > Hey guys
> > > I have some minor issues on my board:
> > > 1) Are there any way to delete the cell value in range A1 when
> > > activating cell/range A2?
> > > - wanted effect is when user activates cell A2 (by click) the value /
> > > content inn cell A1 will be deleted.
> > > 2) When constructing coordinates as textstrings (X Y Z) by linking
> > > values from range B1, B2 and B3 ( the text string will not appear whit
> > > decimal format.– Skjul sitert tekst –
>
> > – Vis sitert tekst –
>
> Thanks - that was a quick one! But I still dont get it right :(
> Right click on sheet tab and paste the macro - right? What did you
> meen by "double click to fire"?
> Regards
> Snoopy– Skjul sitert tekst –
>
> – Vis sitert tekst –

Thats nice! :) Thanks
Are the the same posibility to only activate by one click in this?
Regards Snoopy

You want to clear A1 when you select A2?

Adjust Don's code to this.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address <> Range("A2").Address Then Exit Sub
Range("A1").ClearContents
End Sub


Gord Dibben MS Excel MVP

On Wed, 15 Oct 2008 07:10:24 -0700 (PDT), Snoopy <blaksnm@jjuc.no> wrote:

>Thats nice! :) Thanks
>Are the the same posibility to only activate by one click in this?
>Regards Snoopy

Don's double-click code is better than single-click.

The problem with single-click code is that would also be activated by
getting to A2 with the cursor keys.
--
Gary''s Student - gsnu2007k


"Snoopy" wrote:

> On 15 Okt, 15:51, "Don Guillett" <dguille...@austin.rr.com> wrote:
> > Read the instructions again.
> > You said you wanted to click the cell. This requires a DOUBLE click in b1 to
> > clear a1
> > --
> > Don Guillett
> > Microsoft MVP Excel
> > SalesAid Software
> > dguille...@austin.rr.com"Snoopy" <blak...@jjuc.no> wrote in message
> >
> > news:84c2e159-9bc7-441c-b345-a70d50180c6f@a19g2000pra.googlegroups.com...
> > On 15 Okt, 15:08, "Don Guillett" <dguille...@austin.rr.com> wrote:
> >
> >
> >
> >
> >
> > > #1. Right click sheet tab>view code>insert this. DOUBLE click to fire
> > > #2. More detail?
> >
> > > Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
> > > Boolean)
> > > If Target.Address <> Range("b1").Address Then Exit Sub
> > > Range("a1").ClearContents 'Delete
> > > End Sub
> >
> > > --
> > > Don Guillett
> > > Microsoft MVP Excel
> > > SalesAid Software
> > > dguille...@austin.rr.com"Snoopy" <blak...@jjuc.no> wrote in message
> >
> > >news:4b9593d7-b485-47b0-9c85-36000e4d96aa@40g2000prx.googlegroups.com...
> >
> > > > Hey guys
> > > > I have some minor issues on my board:
> > > > 1) Are there any way to delete the cell value in range A1 when
> > > > activating cell/range A2?
> > > > - wanted effect is when user activates cell A2 (by click) the value /
> > > > content inn cell A1 will be deleted.
> > > > 2) When constructing coordinates as textstrings (X Y Z) by linking
> > > > values from range B1, B2 and B3 ( the text string will not appear whit
> > > > decimal format.– Skjul sitert tekst –
> >
> > > – Vis sitert tekst –
> >
> > Thanks - that was a quick one! But I still dont get it right :(
> > Right click on sheet tab and paste the macro - right? What did you
> > meen by "double click to fire"?
> > Regards
> > Snoopy– Skjul sitert tekst –
> >
> > – Vis sitert tekst –
>
> Thats nice! :) Thanks
> Are the the same posibility to only activate by one click in this?
> Regards Snoopy
>

Very true.

Thanks, Gord

On Wed, 15 Oct 2008 09:49:01 -0700, Gary''s Student
<GarysStudent@discussions.microsoft.com> wrote:

>Don's double-click code is better than single-click.
>
>The problem with single-click code is that would also be activated by
>getting to A2 with the cursor keys.

On 16 Okt, 01:13, Gord Dibben <gorddibbATshawDOTca> wrote:
> Very true.
>
> Thanks, * Gord
>
> On Wed, 15 Oct 2008 09:49:01 -0700, Gary''s Student
>
>
>
> <GarysStud...@discussions.microsoft.com> wrote:
> >Don's double-click code is better than single-click.
>
> >The problem with single-click code is that would also be activated by
> >getting to A2 with the cursor keys.– Skjul sitert tekst –
>
> – Vis sitert tekst –

Thanks everyone. This was really usefull advice :)
Have a nice day
Regards
Snoopy