Re: formatting inputbox

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Nicole,

Try this

marker = Application.InputBox("What is the row number in which " & vbnewline
& _
"the last Cost Center number is located?", , , , , , , 1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Nicole Seibert" <NicoleSeibert@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2B66DC23-3322-48DA-8EFB-58B06D7E0C29@xxxxxxxxxxxxxxxx
Question:

Can I make an inputbox vb anything? When I try this:

marker = InputBox("What is the row number in which the last Cost Center
number is located?", 32)

I get 32 as a title

When I try this:

marker = InputBox("What is the row number in which the last Cost Center
number is located?", vbSystemModal)

I get 32 as a title

When I try this (and lord only knows why I thought this might work!):

marker = InputBox("What is the row number in which the last Cost Center
number is located?", vbSystemModal = False)

I get an error of some sort that was so long ago (this morning) that I
don't
remember.

I need the user to be able to look at the page I just pulled up for them
and
count the number of rows. The data is coming to me from elsewhere and is
formated weirdly. So weirdly I thought it best to just ask the user.

If in case, dear helper, you are interested. I tried to count the rows
from
the bottom up starting at a point in the data in which there are four
consecutive blank cells in column b. Using some manipulation of
ActiveCell
offset several times over in which all of them are blank, etc. That was
yesterday evening. If you believe you have a more fruitful rendition I am
all ears.

Thanks,
Nicole


.