chaticathe
asked on
Need code to make circle within VB and place in Excel cell with number in middle of circle
I have an Excel worksheet that lists the risks on our program. I am developing a risk matrix within another Excel worksheet to depict the ranking of the risks. I want to place a circle within certain cells that depict the ranking of the risk (occurance/impact) along with the number of the risk embedded in the circle. Is it possible to do that? Or do I need to put the number beside the circle? If so, could you provide example code that will do that?
StephenJR
Could you post a sample workbook? Can't quite visualise what you want to do. You can certainly put text inside a circle.
ASKER
The risk matrix is in a separate worksheet. I want to draw a circle in the appropriate cell in the risk matrix according to the ranking of the risk (likelihood and consequence values). I also want to extract the number from the risk number and put inside the circle (1,2,3,4).
Risk-Matrix.pdf
Risks.pdf
Risk-Matrix.pdf
Risks.pdf
Can you post an Excel workbook?
ASKER
Yes. Please see attached.
RIO-Mgmt-test.xlsm
RIO-Mgmt-test.xlsm
What I was after was some indication of the results you were envisaging. Can you add that?
ASKER
Yes, I apologize, please see attached.
RIO-Mgmt-test.xlsm
RIO-Mgmt-test.xlsm
I see now. Presumably if you have more than one entry in a square you want the ovals regularly spaced?
To add to this, how many are likely to be in any square - is there a theoretical or practical limit?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is EXACTLY what I was looking for. Thank you so much...you have saved me alot of time!! I appreciate it more than you know.