Hello to all the helpful souls in this group,
I wish to create a procedure to create a partially absolute formula. And I don't want to do Shift+4 to add $ signs at those places. Here is what I intend to create :
1. I will create a user form wherein the formula of the current selected cell will show up in a text box.
2. User form will have 3 buttons captioned "$A1", "A$1" and "$A$1". And there will be an "Accept" button to replace the formula in the current selection cell.
3. In the formula text, I will select portions where I want to add $ sign and click the relevant "$" Button. $ sign would be added either before row number or column number or both as per the command assigned to the button. I will repeat the selection of text for adding $ signs at multiple places in formula.
4. Button "Accept" closes the form and places new formula in current selection cell.
Can someone help me with code for step 3. Rest I will manage to do myself.
Thanks in advance for your kind help.
I wish to create a procedure to create a partially absolute formula. And I don't want to do Shift+4 to add $ signs at those places. Here is what I intend to create :
1. I will create a user form wherein the formula of the current selected cell will show up in a text box.
2. User form will have 3 buttons captioned "$A1", "A$1" and "$A$1". And there will be an "Accept" button to replace the formula in the current selection cell.
3. In the formula text, I will select portions where I want to add $ sign and click the relevant "$" Button. $ sign would be added either before row number or column number or both as per the command assigned to the button. I will repeat the selection of text for adding $ signs at multiple places in formula.
4. Button "Accept" closes the form and places new formula in current selection cell.
Can someone help me with code for step 3. Rest I will manage to do myself.
Thanks in advance for your kind help.