draw

Anyone know the code to select the a pen of specific color in the draw tool ribbon? OR point me in the direction online? I can't seem to find anything for this online. I'd like to have a button press select the pen. Thanks in advance!

I am trying to make a sports prediction quiz. I would like the scoring to be <tbody> Margin Points Draw 40 Winner 20 Exact 10 1 9 2 8 3 7 4 6 5 5 6 4 7 3 8 2 9 1 </tbody> The selection will be pick, winner, or draw and the points margin of...

Hi everybody! I just started to write some code in VBA and I´m looking for a macro to draw a circle with radius written in a cell. I saw various codes but just to draw a generic circle not with specific radius. Is it also possible to decide the circle position? Thanks so much for any...

Respected sir https://www.dropbox.com/s/4wbozu665e52pgu/25.jpg?dl=0 https://www.dropbox.com/s/7st3gzx0ihv2lw4/Book1.xlsx?dl=0 please find the links above i have attached graph,excel image drawn with pencil in paper i want to draw it in excel by using the Graph(Chart) slopes are taking 0.5:1...

Hi All, I have done many researches but cant seem to find the right 1 to get it to work I want to display a gif file in a certain location in my worksheet without having any scroll bars I have tried to draw the web tool on my machine at both home and work but i get an error saying that i...

Have been playing with signature boxes, etc. Would like to use the inkpicture feature but don't like the active x turned on. If you feel this is the better option and I can turn the active x message off with code when workbook opens, then feel free to share. I'd at least like VBA code to select...

request = to separate the 10 trios, from each line of draw of 5 numbers, then in the group of 5 numbers it is possible 10 formations of three = 000 000 ... ten 000 the macro should be automatic when placing new drawings (updates)...

my intention to draw shape by using cell reference i like to give shape dimensions,angles which i want to draw triangle rectangle...etc in excel

Hi, I'm trying to show historical drawn down (not only the max draw down but each time there is a draw down) of return series, and for each of the drawn down to capture # of periods from Peak to Trough and # or periods to recovery. Draw Down is defined as % decline from previous peak. in the...

Hi all Since last 190 millions last draw of EuroMillions, I've been wondering about statistics and decided to play a little with it, although my lack of knowledge. I've downloaded the list of all draws and extracted it to Excel to check for some indicators in order to improve my luck. Here's...

how can I draw a four bar mechanism in excel using vba can I get the program for it...my four bar should look some what like wat I have uploaded in the pic... n vl I be able to rotate it keeping the upper link fixed...can u plz get me the program

Hi Ive been of excel for a while and have forgotten what to do so please help. I have the formulas listed below and have hade to change the range they refer to. When I enter t=it and hit return the answer in the cell is wrong. =MAX(IF('Draw Results'!C1:C2283={0.3,4},'Draw Results'!A1:A2283))...

I want to create a champions League style group draw if possible through spreadsheet As i'm a beginner to excel I don't have a clue how to do this and I am willing to learn if possible I have 16 teams in columns A1 to A16 I have a seeded section ranging from 1 to 4 with the aim of creating 4...

Hi, I'm struggling with a spreadsheet i'm doing at the minute. I've got a football tournament with 4 groups of 4 at the minute I've done this so the top team goes through to the knockout stage from each group, located in G14, G34, G54 and G74 I've also done the 2nd team in each group to go...

Good Day, I am not new to programming in VB but it has been a while since I have been doing more than just the basic macro builds. I have been asked to try and add some Ovals around designated cells within a worksheet. I would like to run one Macro and have it draw several ovals over the...

Hi, I've been trawling forums for two days now for an answer to this, but with no luck. All I want is the ability for a user to draw within a UserForm, and then what he/she draws to be displayed within a worksheet. InkPicture would seem the correct control to be using, but I can't find a way...

Hi guys, It would be great if you could help. I need a formula to run a draw / sweepstakes. Let's say there is a list of 500 names in the column B (numbers 1-500 in the column A) and I need to select 20 names at random without any doubles. So far I only managed to come up with the formula...

I have a series of percentages by location that I want to plot on a bar chart and then have a line through at the level of the average percentage for the region so you can seen very clearly which location are abouve and which are below the regional average. I tried drawing a line from the draw...