Trentoes
Mechanical
- Oct 22, 2007
- 1
Hey guys,
I'm currently undertaking a project where I have to use VBE for Excel (which I'm not too familiar with). So the problem is... I've created a box (just a normal rectangle) for a graph and I have to draw scaled tick on... ie. marks for the axis' every increment. This is the suggested form...
Private Sub DrawScales()
If the distance increment is greater than zero Then
DrawDistScale distincrement
End If
If the elevation increment is greater than zero Then
DrawElevScale elevincrement
End If
End Sub
Does anyone know how to do this? I've attached the excel file so you can see what's going on... Just scroll down to the above section... Your help is greatly appreciated! Cheers,
Trent
I'm currently undertaking a project where I have to use VBE for Excel (which I'm not too familiar with). So the problem is... I've created a box (just a normal rectangle) for a graph and I have to draw scaled tick on... ie. marks for the axis' every increment. This is the suggested form...
Private Sub DrawScales()
If the distance increment is greater than zero Then
DrawDistScale distincrement
End If
If the elevation increment is greater than zero Then
DrawElevScale elevincrement
End If
End Sub
Does anyone know how to do this? I've attached the excel file so you can see what's going on... Just scroll down to the above section... Your help is greatly appreciated! Cheers,
Trent