I guess that's good to know
On Tuesday, August 20, 2013 2:23:33 AM UTC-4, ashish wrote:
>
> Hi
>
> Excel 2008 mac does not support VBA .
> http://en.wikipedia.org/wiki/Microsoft_Office_2008_for_Mac
>
> http://www.mac-forums.com/forums/switcher-hangout/159791-excel-2008-no-vba.html
>
> It might b
I don't have any knowledge about Mac Excel . So can't help you much :(
On Tue, Aug 20, 2013 at 12:01 PM, Chaya Cooper wrote:
> For some reason it doesn't work when I do that :-( Any suggestions?
>>
>>
> Also, is there a way to do it for all the images at once? (Not sure if it
> helps, but they
Alt + Fn +F11 just minimizes the window :-(
On Tuesday, August 20, 2013 2:17:28 AM UTC-4, ashish wrote:
>
> if you are using mac excel then try Alt + Fn +F11
>
> source:
> http://www.excel4mac.com/2010/01/shortcut-to-access-visual-basic-editor.html
>
>
> On Tue, Aug 20, 2013 at 11:43 AM, ashish
see if it helps
Sub sample()
Dim i As Long
Dim st As Long
Dim j As Long
j = 3
st = 1936
For i = 2 To Range("a65356").End(xlUp).Row
If IsNumeric(Cells(i, 1).Value) And Cells(i, 1).Value <> "" Then
If Cells(i, 1).Value = st + 1 Then st = st + 1
Cells(j, 10).Value = st
Cells(j, 11).Va
I guess that's good to know. Unfortunately I'm only using this
this computer temporarily, so I'm not able to upgrade the software :-(
On Tue, Aug 20, 2013 at 2:31 AM, P.VIJAYKUMAR wrote:
> Respected Chaya,
>
> Unfortunately macros or VBA interface is not available with Excel 2008 for
> MAC.You
Respected Chaya,
Unfortunately macros or VBA interface is not available with Excel 2008 for
MAC.You must upgrade to Excel 2011 of chane to windows operating system to
use Excel 2007,2010 or Excel 2013.The shortcoming or limitations of Excel
2008 are given in the below link.
http://en.wikipedia.org
Hi
Excel 2008 mac does not support VBA .
http://en.wikipedia.org/wiki/Microsoft_Office_2008_for_Mac
http://www.mac-forums.com/forums/switcher-hangout/159791-excel-2008-no-vba.html
It might be reason that its not thr in right click
Regards
Ashish
On Tue, Aug 20, 2013 at 11:47 AM, ashish ko
if you are using mac excel then try Alt + Fn +F11
source:
http://www.excel4mac.com/2010/01/shortcut-to-access-visual-basic-editor.html
On Tue, Aug 20, 2013 at 11:43 AM, ashish koul wrote:
> press alt +f11
>
>
> On Tue, Aug 20, 2013 at 11:25 AM, P.VIJAYKUMAR wrote:
>
>> Respected Chaya Cooper,
press alt +f11
On Tue, Aug 20, 2013 at 11:25 AM, P.VIJAYKUMAR wrote:
> Respected Chaya Cooper,
>
> Please check the following link and see whether it helps.
> http://excelsemipro.com/2011/05/create-a-list-in-excel-2008/
>
> To view code you can also open the VBA window by pressing ALT+F11 and g
Vijaykumar,
That's actually a great tutorial, so thank you for showing it to me :-)
Unfortunately it doesn't show how to view the code :-(
When I select ALT+F11 nothing happens (is there another way that i need to
do it in Mac?), and I'm having trouble figuring out another way to open it.
Any
Respected Chaya Cooper,
Please check the following link and see whether it helps.
http://excelsemipro.com/2011/05/create-a-list-in-excel-2008/
To view code you can also open the VBA window by pressing ALT+F11 and go to
project explorer window and go to the module folder to open it and see the
cod
have you tried using form controls or active x control list box for multi
select options
On Tue, Aug 20, 2013 at 10:57 AM, Chaya Cooper wrote:
> And these are the options that are displayed when I right-click on the tab
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
=OFFSET('Sample - Unedited'!$A$1,COLUMN('Sample -
Edited'!A1)+(COUNTA($A$1:$C$1)*(ROW(A1)-1)),0)
'Sample - Unedited'!$A$1 - header of source column
COLUMN('Sample - Edited'!A1) - will give us 1 , 2 , 3
(COUNTA($A$1:$C$1)*(ROW(A1)-1)) will give us 0 , 3, 6
'
0 because source data is in same col
Dear Chaya
The solution from Ashish (using offset command) has lesser effort than
using macro. I suggest to use the same for your multiple entries.
using macro is possible in 2008 . no issue. For your information. you have
to use Ctrl+ shift + A at first column of each row required.
Regards
Pra
Ashish,
That's exactly what I needed :-D
Would you mind showing me how to use it?
- Chaya
On Tuesday, August 20, 2013 12:50:23 AM UTC-4, ashish wrote:
>
> Hi try the attachment . see if it helps
>
>
>
>
> On Tue, Aug 20, 2013 at 9:46 AM, Prashant Pednekar
>
> > wrote:
>
>> Hi Chaya, Prabhu,
Hi Prashant,
I've only used macros a few times, and am having trouble a wee bit of
trouble figuring things out because I'm temporarily using a Excel 2008 for
Mac :-( (I'm normally a PC gal, with Office 2007 ;-))
Can I trouble you to explain when I should use Control + Shift + A, and how
to op
Hi try the attachment . see if it helps
On Tue, Aug 20, 2013 at 9:46 AM, Prashant Pednekar wrote:
> Hi Chaya, Prabhu,
>
> Done with a simple macro.
>
> Use Control + Shift + A at particular cell where you want to transpose.
>
> This you have to to for every entry.
>
> In case you want it for
Dear Chaya,
Pl share a sample sheet with us.
Warm Regards,
Gawli Anil.
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Aug 20, 2013 at 6:00 AM, Chaya Cooper wrote:
> A tutorial I'm using (to create a multi-select box) suggests right-clicking
Dear Ashkan,
on textbox enter event write a code
Me.txtshiptoparty.BackColor = vbGreen
after on textbox exit event write again the same code with different color.
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Aug 20,
can u share a sample file
On Tue, Aug 20, 2013 at 3:38 AM, ashkan kordmahaleh wrote:
> I am trying to use some VBA to change backcolor of my userform txtbox when
> the linked cell value changes. Any ideas?
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME
try this
Sub choose_file()
Dim flname As String
Dim fd As FileDialog, fl As Variant
Set fd = Application.FileDialog(msoFileDialogFilePicker)
With fd
.AllowMultiSelect = True
.Title = "Please choose the file"
.Filters.Add "Excel Files", "*.xls*", 1
.
Am just asking you to share the excel file.
On 20-Aug-2013 5:50 AM, "Chaya Cooper" wrote:
> I'm sorry, I'm not sure I understand what you're saying :-(
>
> On Monday, August 19, 2013 7:24:56 PM UTC-4, Prabhu Pinky wrote:
>>
>> hi chaya,
>>
>> hope if u share the file.. it will be so fine to work.
A tutorial I'm using (to create a multi-select box) suggests right-clicking
on the sheet tab to View Code, but that option isn't being displayed (I'm
running Excel 2008 for Mac). Any suggestions how I can view the code?
My apologies for what is probably a simple issue, but I've been unable to
I'm sorry, I'm not sure I understand what you're saying :-(
On Monday, August 19, 2013 7:24:56 PM UTC-4, Prabhu Pinky wrote:
>
> hi chaya,
>
> hope if u share the file.. it will be so fine to work.
>
>
> Thanks & Regards,
> Prabhu R
>
>
> On 20 August 2013 04:35, Chaya Cooper >wrote:
>
>> Unfortun
paste this on userform1
'
Dim Target As Range
Private Sub CommandButton1_Click()
Target.Offset(1).Select
Unload Me
End Sub
Private Sub TextBox1_Change()
Target = TextBox1.Text
End Sub
Private Sub UserForm_Activate()
Set Target = Selection
TextBox1.Text = Tar
hi chaya,
hope if u share the file.. it will be so fine to work.
Thanks & Regards,
Prabhu R
On 20 August 2013 04:35, Chaya Cooper wrote:
> Unfortunately, the data in each row is different
>
> I've attached an image with an example :-)
>
>
> On Mon, Aug 19, 2013 at 6:36 PM, Prabhu Pinky wrote
you mean same data in each row..?.. or can you share me your file with
requirement..?
like below..
[image: Inline images 1]
Thanks & Regards,
Prabhu R
On 20 August 2013 04:02, Chaya Cooper wrote:
> That's amazing :-D I'm sorry I waited this long to ask ;-)
>
> One question - is there a way
That's amazing :-D I'm sorry I waited this long to ask ;-)
One question - is there a way to split it up into several rows (for example
5 rows, with 3 columns per row)?
On Monday, August 19, 2013 6:21:59 PM UTC-4, Prabhu Pinky wrote:
>
> Hi Chaya,
>
> You no need to cut and paste the each cells.
Hi Chaya,
You no need to cut and paste the each cells. Simply u just copy the data
which u need to be in row. then right click->paste special->values (and
select transpose). Now you data will be pasted in single row.
Note the same method u can use to copy the data in single column if it is
in sin
I often use Excel to organize rows of text (i.e. terminology, examples,
subsets, etc.) and often need to include images in a row. However since
images aren't actually in a specific cell they therefore aren't linked to
the rest of the information in the row, making it impossible to sort the
data
I am trying to use some VBA to change backcolor of my userform txtbox when
the linked cell value changes. Any ideas?
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discusse
I often have to move cells in order to have them in a row (going across)
instead of in a column (going down). Is there a way to simplify this so
that I don't have to manually cut & paste or move each cell?
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,
Hi Friends,
Please suggest me vba code to enter the text in A1, A2, A3..likewise
by using VBA Userform textbox. I have attached sample file for you
reference. Double click on cell A1, A2 will open the useform for which
I need the code.
Thanks in advance.
--
With regards,
*MaNgEsH*
--
Are you
Dear Ahsish
waiting for help
Regards
Shrinivas
On Sat, Aug 17, 2013 at 11:50 AM, Shrinivas Shevde
wrote:
> Dear Ashish
> Please find attached File
>
> Regards
> Shrinivas
>
>
> On Sat, Aug 17, 2013 at 9:41 AM, ashish koul wrote:
>
>> Hi can u share some sample files and output workbook
>>
>>
>
Dear Indarjit
Can you share a file with me because I have the same work
Regards
Shrinivas
On Mon, Aug 19, 2013 at 2:33 PM, Indrajit $nai wrote:
> Thanks a lot to both of you.
>
> You guys are simply awesome :)
>
>
> On Mon, Aug 19, 2013 at 12:31 PM, ravinder negi wrote:
>
>> add below "M
Thanks a lot to both of you.
You guys are simply awesome :)
On Mon, Aug 19, 2013 at 12:31 PM, ravinder negi wrote:
> add below "Microsoft Scripting Runtime" library from tool-->reference
>
>
> --
> *From:* Indrajit $nai
> *To:* excel-macros@googlegroups.
Dear Shrinivas,
Pl see that u have filter the ext with the following one.
.Filters.Add "Excel", "*.xls; *.xlsx; *.xlsm; *.xlsb", 1
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Mon, Aug 19, 2013 at 2:24 PM, Shrinivas
Dear All
I am facing a small problem I like to have help for expert.
I am trying to write a macro which will browse the folder and open the
selected file one by one.
But whenever I am opening a folder from macro I could not see any file in
that folder.
If I am opening the same folder directly there
PFA.There are three argument in UDF first lookup value ,
lookarea(range),colnum
From: Rashid Khan
To: excel-macros@googlegroups.com
Sent: Sunday, August 18, 2013 9:32 PM
Subject: $$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited
with ]
add below "Microsoft Scripting Runtime" library from tool-->reference
From: Indrajit $nai
To: excel-macros@googlegroups.com
Sent: Monday, August 19, 2013 4:08 AM
Subject: $$Excel-Macros$$ Need urgent help on macro error.
Hi All,
Kindly find attached the
Hello,
Thanks for the reply.
Output required is group concatenate. As you can see I have shown that in
the sample file.
Codes are used to mark the questions.
Then it will come as an output in the Answers Column.
I need to get the concatenated values from the Text Columns
Hope it is clear
Regards
41 matches
Mail list logo