ThisComponent.Sheets(0).getCellByPosition(1,1).String = myText MyText = oDialog1.getControl("TextField1").getText() Need to hold the text entered in textfield control and put it into Cell B2 (i.e. Send_to_calc() function is also very simple. We need to define a variable to hold the dialog object and execute it. Start_form() function is very straightforward.
Second function – send_to_calc() would take the text from the dialog and put it to a cell (say B2) in Calc. First function – start_form() would start the dialog we have designed. Open the Form Control toolbar from View -> Toolbars -> Form ControlsĬlick on the Button icon in Form Controls box and drag and draw a button in Calc sheet. The design may look like this:Īdding a push button on the Calc sheet is bit different from adding it in a dialog. Click NEW to create a dialog and then click Edit to enter design mode.ĭrag a TextField and Command Button control to the dialog. Open Organize Dialogs from Tools -> Macros. Create a DialogĬreate a dialog with a TextField and CommandButton control. When the dialog’s button is clicked, we would send the text from the textbox to inside a cell of Calc sheet. Create a dialog with a textbox and a button. ObjectiveĪdd a button on top of CALC sheet. Many times, it is needed to have a quick button on the Calc sheet itself and perform some tasks or run a macro when the button is clicked.
0 kommentar(er)
