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).
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
