Searching for VBA specialist

Need to write a toolkit for setting and editing a chain of a sequence of numbers, for the CorelDRAW graphic editor.

There is an initial layout, it has a lot of scattered text frames in different locations, each with its own assigned name in the object manager. There are numbers inside the text frames. Each digit in these frames has its own pair (a different frame, but inside with the same number value).

What you need to do:
- create a function for changing the value of numeric pairs at the same time;
- simplify it to simply clicking the mouse over text frames, without the need to write numbers manually: new numbers are put down depending on the sequence of mouse clicks;
- to ensure work with "chain links" in this sequential numbering, i.e. when one numeric pair is removed from the chain, the subsequent ones are rebuilt by -1, when added — by +1;
- make it possible to graphically display the sequence, for example, when activating this function, two connected connecting lines are drawn from the number 2 (there is a tool in CorelDRAW), showing where the numeric pairs 1 and 3 associated with it are located.

I am ready to answer any questions. I am ready to pay for the work via PayPal

  • Your theme is not clear enough, I am afraid...

    1. How the required function should know what numeric pair text to be changed? I mean, how do you like it to identify the pair?

    2. Are you referring to the first issue? Should the function change the text if one of the pair text box element will be clicked? What does "depending on the sequence of mouse clicks" mean? How specifying to what value to be changed?

    3. I do not understand what you need. What do you mean by "chain links"? The total pairs in discussion? If so, how to proceed if pair 3-3 will be removed? Should all existing pairs keeping bigger numbers to have their value decreased by 1? If not, please better explain what you need and when such a function to run? Should it detect somehow the pair removing? Should it detect one pair element removing, then deleted the second one and apply decreasing to the larger following pairs?

    4. So, you want clicking on such a text box (to select it) and then running the required function/sub to create a connector between the selected one and the "associated" pairs? You did explain anything about this association until now, but let us suppose that you need the precedent (the one having a number less with a unit)  and the subsequent (the following one). Now, if you click on the text box keeping 1, which to be the precedent? The same for the larger number and the subsequent. Then, since there are two such pairs (precedent and subsequent), which of them to be connected to the clicked one? All four? And supposing that you will clarify the issue, you should also state what will happen with the created connectors? Will they remain on the page? Is it necessary another procedure to remove them? If so, all existing, the selected ones?

  • I see that you are using a Russian-language CorelDraw. In this case, write in Russian what needs to be done?