$$Excel-Macros$$ hiya
hi there have cells on another sheet of my workbook and was wondering how i use these to populate a combo box. alex cargill ps i use excel 2010 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Removing selected letters and symbols from a cell
Hi all I was wondering if you could help. I have a sheet with entrys into a cell that looks like this: AAECHO::DELTA (422|279) K24 AALPHA::HOTEL (447|319) K34 ALPHA::FOXTROT (445|320) K34 ALPHA::GOLF (446|319) K34 ALPHA::INDIGO (448|320) K34 ALPHA::JULLIET (449|319) K34 ALPHA::KILO (448|323) K34 BRAVO::ALPHA (459|317) K34 BRAVO::DELTA (463|318) K34 CHARLIE::BRAVO (426|330) K34 All I want to be left with is a sheet with entry's like this: 422|279 447|319 445|320 446|319 448|320 449|319 448|323 459|317 463|318 426|330 And the data that has K and a number behind it in a separate column(there is multiple K numbers). If you could help ide be most grateful. Many thanks Alex Cargill -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
RE: $$Excel-Macros$$ Re: Help needed in changing this code
Absolutely perfect mate :P may thanks
Alex cargill
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Kishan Reddy, K
Sent: 16 August 2010 08:13
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Help needed in changing this code
Just Try this code.
Dim CELL As Variant
Range("B2:B105").Select
For Each CELL In Selection
If IsEmpty(CELL) Then
With CELL.Offset(0, -1).Interior
.ColorIndex = 3
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
Else
With CELL.Interior
.ColorIndex = 10
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
End If
Next
You may need to change the colorindex as per your pallate.
Regards,
Kishan Reddy, K
kishanreddy.kethire...@gmail.com
On Aug 16, 6:05 am, Alexander Cargill
wrote:
> Hi all
>
> I have been working on the following piece of code to identify Blank
> Cells and turn them red:
>
> Range("B2:B105").Select
>
> Selection.SpecialCells(xlCellTypeBlanks).Select
>
> ActiveWindow.SmallScroll ToRight:=-1
>
> With Selection.Interior
>
> .Pattern = xlSolid
>
> .PatternColorIndex = xlAutomatic
>
> .Color = 255
>
> .TintAndShade = 0
>
> .PatternTintAndShade = 0
>
> End With
>
> Range("B15").Select
>
> I would like to expand the code to do the following:
>
> 1 expand this code so it searches the B column but instead off turning
> the Blank cells in column B red it turns the cells Ajacent to the
> blanks in column A Red
>
> 2 I would like to turn the cells that are adjacent to the cells that
> are not blank green
>
> If you could help with this I would be most greatful
>
> Alex Cargill
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip 2. Join our LinkedIN group @
http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and
Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about
the learning and support from the group.Let friends and co-workers know they
can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Help needed in changing this code
Hi all
I have been working on the following piece of code to identify Blank Cells
and turn them red:
Range("B2:B105").Select
Selection.SpecialCells(xlCellTypeBlanks).Select
ActiveWindow.SmallScroll ToRight:=-1
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 255
.TintAndShade = 0
.PatternTintAndShade = 0
End With
Range("B15").Select
I would like to expand the code to do the following:
1 expand this code so it searches the B column but instead off turning the
Blank cells in column B red it turns the cells Ajacent to the blanks in
column A Red
2 I would like to turn the cells that are adjacent to the cells that are not
blank green
If you could help with this I would be most greatful
Alex Cargill
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
RE: $$Excel-Macros$$ How to alter the contents of a row in a sheet
Absaloutly perfect mate J thanks so much From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Aindril De Sent: 07 July 2010 02:25 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to alter the contents of a row in a sheet Hi Alex, Please find attached the solution. I have used the following code inside a module Sub village() ' This loop runs until there is nothing in the last cell ' Aindril De (Andy) Do ActiveCell.Value = "[village]" & ActiveCell.Value & "[/village]" ActiveCell.Offset(1, 0).Select Loop Until IsEmpty(ActiveCell) End Sub To run this code. click on the first cell where you want to start the changes (in my example it is cell B2) and then click on the button named village. Pl let me know if u need any further help on this. Cheers!!, Andy On Tue, Jul 6, 2010 at 8:11 PM, Alexander Cargill wrote: Hi All I was wondering if you could help. I have a column of data which is Column B within a sheet that I wish to alter, the data has the following format : XXX|XXX and I wish to change the contents of the cells in the column from XXX|XXX to [village]XXX|XXX[/village] using a single button. So essentially I want to add the text [village] before the co-ords and the text [/village] after the co-ords in each cell in column B can anyone help?? Thanks very much Alex Ps I can supply the sheet if needed J -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ How to alter the contents of a row in a sheet
Hi All I was wondering if you could help. I have a column of data which is Column B within a sheet that I wish to alter, the data has the following format : XXX|XXX and I wish to change the contents of the cells in the column from XXX|XXX to [village]XXX|XXX[/village] using a single button. So essentially I want to add the text [village] before the co-ords and the text [/village] after the co-ords in each cell in column B can anyone help?? Thanks very much Alex Ps I can supply the sheet if needed J -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ inserting text to change contents off a cell
Hi all I was wondering if you could help, if you look at the following work book and the sheet that is called Bogy sets to attack there is co-ordinates in them, what I would like to do is select the contents off the column in a box (so I can selectively change them) and change the entry from XXX|XXX to [village]XXX|XXX [/village] by using either a check box or a button. If anyone can help ide be most greatful. Alex Cargill -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe K26 and 36 notes.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: Is this possible and how
My fault for nt explaining J sorry my ma and much appreciated J
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Dave Bonallack
Sent: 22 October 2009 05:41
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Is this possible and how
Hi Alex,
Didn't realise you were talking about a form, sorry. Can't help you on your
actual query. Outside my area of experience.
Regards - Dave.
_
From: zanderman1...@googlemail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Is this possible and how
Date: Wed, 21 Oct 2009 15:20:24 +0100
ah hi see, I think its my fault for not explaining properly, ill email you a
copy off the sheet to let you see, you will see the form called farm take a
look at that J
alex
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Dave Bonallack
Sent: 21 October 2009 06:02
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Is this possible and how
Hi Alex,
Not sure if this is helpful, but it's something to consider.
A macro can identify the button that called it, and the text on that button.
So you can have just one macro, with lots of different buttons calling it.
The code within the macro can do different things depending on which button
called it, or the text on the button that called it.
For example:
On Error GoTo Ext:
Dim X As Range
A = Application.Caller 'The variable 'A' now holds the Button Object
that called the macro
B = ActiveSheet.Buttons(A).Characters.Text'The variable 'B' now
holds the text from that Button
If B = "Text A" Then
Set X = Columns("D:D").SpecialCells(xlCellTypeBlanks)
If B = "Text B" Then
Set X = Columns("F:F").SpecialCells(xlCellTypeBlanks)
If B = "Text C" Then
Set X = Columns("H:H").SpecialCells(xlCellTypeBlanks)
X.Cells(1, 1) = 7
X.Cells(1, 2) = 58
Ext:
Exit Sub
Change Text A, Text B, Text C to whatever text you have on your buttons.
If 50 of your buttons have one text, and the other 50 have another text,
then you'll only need 2 choices.
Regards - Dave.
> Date: Tue, 20 Oct 2009 10:21:53 -0700
> Subject: $$Excel-Macros$$ Is this possible and how
> From: zanderman1...@googlemail.com
> To: excel-macros@googlegroups.com
>
>
> Hi all in VBA 6.5 I have this code that i was supplied by one off your
> members which works fine:
>
> On Error GoTo Ext:
> Dim X As Range
> Set X = Columns("D:D").SpecialCells(xlCellTypeBlanks)
> X.Cells(1, 1) = 7
> X.Cells(1, 2) = 58
> Ext:
> Exit Sub
>
> Having used this code on 50 Option buttons and changing the X.Cells
> Values to suit, I now need to cpoy and paste the same code another 100
> times But changing the D:D values to F:F for 50 buttons and H:H for
> the remaining 50. Can anyone help or do i really have to do this all
> manualy??
>
> alex
>
>
> http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---
$$Excel-Macros$$ Is this possible and how
Hi all in VBA 6.5 I have this code that i was supplied by one off your
members which works fine:
On Error GoTo Ext:
Dim X As Range
Set X = Columns("D:D").SpecialCells(xlCellTypeBlanks)
X.Cells(1, 1) = 7
X.Cells(1, 2) = 58
Ext:
Exit Sub
Having used this code on 50 Option buttons and changing the X.Cells
Values to suit, I now need to cpoy and paste the same code another 100
times But changing the D:D values to F:F for 50 buttons and H:H for
the remaining 50. Can anyone help or do i really have to do this all
manualy??
alex
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: getting option buttons to work
many thanks for that code, it works a proper treat :, alex
On 17 Oct, 01:37, Hemant Hegde wrote:
> Use this code friend
>
> Sub Test()
> On Error GoTo Ext:
> Dim X As Range
> Set X = Columns("D:D").SpecialCells(xlCellTypeBlanks)
> X.Cells(1, 1) = 1
> X.Cells(1, 2) = 30
> Ext:
> Exit Sub
>
> --
> Hemant Hegde
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: getting option buttons to work
Hi there just wanted to say your code worked a treat, many many thanks to ya
J
alex
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Hemant Hegde
Sent: 17 October 2009 01:38
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: getting option buttons to work
Use this code friend
Sub Test()
On Error GoTo Ext:
Dim X As Range
Set X = Columns("D:D").SpecialCells(xlCellTypeBlanks)
X.Cells(1, 1) = 1
X.Cells(1, 2) = 30
Ext:
Exit Sub
--
Hemant Hegde
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---
$$Excel-Macros$$ getting option buttons to work
Hi all im a bit off a noob and i was wondering iif you can help. I have a form with an option box I want the option box first search for the first blank cell in the D coulmn and then place the number 1 in the first available blank box in column D and in the ajacent cell the number 30 can anyone help please?? alex --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
