Have you looked at this resource? Converting VBA to OpenOffice Basic.
Also there is a PDF that explains the porting process: Porting Excel/VBA to Calc/Star Basic
Thx much, Mark. Will look into that.