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
press alt +f11
On Tue, Aug 20, 2013 at 11:25 AM, P.VIJAYKUMAR vijay.4...@gmail.com 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
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
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.
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).Value =
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 koul
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 chayacoo...@gmail.comwrote:
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
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 be reason
Dear Anil and Ashish
Thanks problem solved
Regards
Shrinivas
On Tue, Aug 20, 2013 at 9:32 AM, ashish koul koul.ash...@gmail.com wrote:
try this
Sub choose_file()
Dim flname As String
Dim fd As FileDialog, fl As Variant
Set fd = Application.FileDialog(msoFileDialogFilePicker)
Thanks a ton !!!
On 8/20/13, De Premor d...@premor.net wrote:
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
Thanks Ravinder,
Couple of things if you would kindly rectify it please.
1) For some reason, the UDF does not work for codes which is not on the
active sheet. I had posted my problem for sake of explanation on the same
sheet but in reality it is on other sheet.
2) If you could please
try to replace current code with this
Function LookForCode(Str As String, Data As Range, Colx As Integer,
Optional Delim As String = ])
Dim Kode, Tmp As String
For Each Kode In Split(Str, Delim)
If Kode Then Tmp = Tmp
WorksheetFunction.VLookup(Kode, Data, Colx, 0)
Anyone know where I can get some Addin for digitizing data from graphical
line/chart images in excel.
--
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/discussexcel
FORUM
I am open to suggestions on how best to go about this and am aware this
might be a fairly simple request but I either lack the expertise or the
correct vernacular to find the answer myself.
On a daily basis I receive files of approximately 56000 rows of part
numbers along with each parts
Dear All,
Very Good Morning,
I have made 10 charts and now I want to change the Size of Font 14 to 9
for Chart Title.
is it possible to change it through the VBA
for example
For each
For Next
Do until
if yes , Please provide the same
Thanks in Advance
Regards,
Prafull Jadhav.
--
15 matches
Mail list logo