2013/10/22 Tom Davies <[email protected]> > Hi :) > It is interesting that it works at all! LibreOffice uses a slightly > different programming language for it's macros so often people have to > translate the MS ones into LibreOffice Basic (or Python or whatever else). >
Maybe ”Option VBASupport 1” has something to do with it? Johnny Rosenberg > > Since the statements are so simple this time i wonder if it just needs some > tweaking or needs to be copy&pasted into a fresh new macro or something? > Hopefully someone on this list will be able to give you a much better > answer! > Good luck and regards from > Tom :) > > > On 22 October 2013 06:35, Heena Gupta <[email protected]> wrote: > > > Hi guys, > > > > When i run the MS Excel macro in libre office, it runs correctly but > shows > > the output while clicking on the cell on which output comes. > > > > > > Option VBASupport 1 > > Sub Button1_Click() > > Dim a As Integer > > Dim b As Integer > > Dim c As Integer > > Range("B1").Select > > a = ActiveCell.Text > > Range("B3").Select > > b = ActiveCell.Text > > c = a + b > > Range("B8").Select > > ActiveCell.FormulaR1C1 = c > > End Sub > > > > Thanks & Regards, > > Heena Gupta > > > > -- > > To unsubscribe e-mail to: [email protected] > > Problems? > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > > List archive: http://listarchives.libreoffice.org/global/users/ > > All messages sent to this list will be publicly archived and cannot be > > deleted > > > > > > -- > To unsubscribe e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
