VB in HTML

[ramnewbietoaccess]

Working in FrontPage, I have a drop down box "D1"
and an excel spreadseet "Spreadsheet 1". I am trying to get the value from D1 to populate the spreadsheet in A1.

I am using this. Am I close??

<select size="1" name="D1">
<option value="1">Mustang</option>
<option value="2">Escort</option>
</select<</p>
<SCRIPT LANGUAGE = "VBScript"
<!--
If D1.Value = 1
Then Spreadsheet.Range("A1").= Mustang<- -></SCRIPT>
</form>

Thanks in advance for looking at this.