View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default InputBox and UserForm

You don't "pull" values into a cell from VB (unless you are talking about a
UDF), you "push" them into whatever cell you want. For example...

ActiveCell.Value = InputBox("Type something...")

You didn't give any information as to exactly what you are trying to do, so
I just gave a simple example.

--
Rick (MVP - Excel)


"Bill Johnson" <Bill wrote in message
...
How do I pull the contents of my InputBox or UserForm into my Excel 2003
spreadsheet? Are there any examples out there?