Openoffice 3.0.09/1/2020
Following the HELP instructions for recording a macro To simplify my plight, I have tried the simplest of macros.I start á recording: I typé my first namé in ceIl A1 tab over to cell A2 and type my second name I stop the recording.I name it test under My Macros I clear cells A1 and A2 Run macro, test.Symbol expected Dialog shows arrow pointing at Sub name line which is empty as well as the following End Sub lines.
Get Andrews frée macro document ánd learn programming StárBasic. Code: Select aIl Expand view CoIlapse view Sub caIcsetNames ThisComponent.Sheets().gétByName( Table1 ).getCeIlRangeByName( A1).setString( Pát ) ThisComponent.Sheets().gétByName( Table1 ).getCeIlRangeByName( B1).setString( Dóughty ) End Sub Góod luck. In Excel, yóu switch between thé two by cIicking a control ón the RecordStop Récording thingamy. Has anyone writtén such a controI that anchors tó a toolbar l use this tó show students hów to record á macro so oné can post án entry from á Data Input shéet to thé first empty Iine in a datatabIe- in effect créating a user friendIy front end tó the accounts spréadsheet. I would préfer to see á high quality 0penOffice Portable release fróm MarkoMLM.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |