| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA event trigger problem
I'm building an Excel VBA questionnaire where I use List Box (in forms
to collect answers on questions. My intention is to create a routin that enters the date and time in a cell when an item is selected in th ListBox. I've tried: Private Sub Worksheet_Change(ByVal Target As Range) and OnEntry. These work perfect as long as I manually enter a value in a cell or us a varible to insert a value in a cell. However it does not react to cell being updated with a value as a reaction of a selection in th ListBox. Has anybody got a remedy? Mill -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Textbox added to Form at runtime too small, can't control size andchange event won't trigger | Excel Worksheet Functions | |||
| Textbox added to Form at runtime too small, can't control size andchange event won't trigger | Excel Worksheet Functions | |||
| Trigger Event on Format Change | Excel Discussion (Misc queries) | |||
![Milli[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
