Ok heres the thing,

Im trying to make it so that a inputbox is prompted and the result
is entered into the worksheet. Heres my problem, i can get it to insert
onto a singlecell but i was wondering how do i make it so that it
checks the cell above it to see if its empty and if it is how do i make
it enter the result from the inputbox onto the next row?

So far ive got

Private Sub CommandButton1_Click()

'declare variables as types
Dim saveURL As String

'gets title from user
saveURL = InputBox(Prompt:="Please enter the title of the URL:", _
Title:="Enter Title of URL", Default:="(enter URL title)")

'check to see if cell is empty
[dont know how to do this]

Attachment filename: mylinks.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=583983
---
Message posted from http://www.ExcelForum.com/