Ask Your Question

BASIC|Calc: Progress bar [closed]

asked 2019-11-10 07:47:19 +0100

lonk gravatar image

From this demo code, how can I apply the actions as hereunder to work with this progress bar ?

[Data range : From Calc row 6 to 999]
[Start progress bar dialog]
[For 6 To 999]
[Connect database]
[Retrieve data from cells of a Calc row]
[Insert data as above into database]
[Disconnect database]
[Progress bar increases its status]
[Progress bar completes and closes ]

And is it possible to pass the variable of min and max value to

Sub ProgressBarDemo(MinStart, MaxEnd) ?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2019-11-12 19:52:44.914056


1 Answer

Sort by » oldest newest most voted

answered 2019-11-10 20:02:34 +0100

Ratslinger gravatar image


Using the sample code works as is and it is only a matter of placing your code in the proper spot and how you want the progress bar to increment.

Sample is attached. Code is nearly identical to your link. Added InputBox (see -> InputBox Function [Runtime] to allow for variables. You can also pass in a variety of other methods. In addition to the progress bar, Cell A10 will show the progress value and when finished display "Done".

Sample --- DialogWithProgressBar.ods

edit flag offensive delete link more



You should be able to change:

Const ProgressStep = 4


Const ProgressStep = 1

in order to use ProgressValue to access your rows.

Edit: Also note, did not put in any checking for values entered. First input should be less than second input.

Ratslinger gravatar imageRatslinger ( 2019-11-10 20:30:46 +0100 )edit

Dear @Ratslinger ,

Thank you so much for all your help.

lonk gravatar imagelonk ( 2019-11-11 10:16:21 +0100 )edit

Question Tools

1 follower


Asked: 2019-11-10 07:47:19 +0100

Seen: 36 times

Last updated: Nov 10