LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default Form Popup

Got this code that needs modifying ,can you help?

What goes here?
If Target.Column = 12 Then
ActiveSheet.ShowDataForm
End If
End Sub
Where to put it, and how do you specify what columns you want to use and
where the data goes. I may not be using the right form. I like Excels form
because you can keep entering data and it will put it in the right columns
as you enter it in a spreadsheet if you select forms from the menubar in
excel not VBA. Is there another type of form that you can use that you can
get it to popup when a specific cell is selected and have predefined headers
and have the data entered to be put it a specific place. What I am trying to
do is ,I have got a range of cells from L10 to L160 that I hope to use as
the trigger(selecting the cell and pressing enter), when L10 is selected
Hopefully this popup will popup and have 3 different Headers(associated with
3 different columns) with data fields, now there might be 1 or 30 entries
per header and it needs to be able to accommodate that.
Thanks<
Still Learning
David


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Popup Input Box Dolphinv4 Excel Discussion (Misc queries) 6 May 10th 08 05:02 PM
Excel POPUP [email protected] Excel Worksheet Functions 0 March 26th 08 12:02 PM
Research Popup Nigel Excel Discussion (Misc queries) 0 June 3rd 05 08:10 PM
"Why did we get here????" popup jtwspoon Excel Discussion (Misc queries) 3 February 4th 05 04:57 AM
Popup form from Excel not VBA David W[_3_] Excel Programming 0 July 18th 03 02:37 PM


All times are GMT +1. The time now is 02:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"