Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 226
Default Accessing selected cell from modal dialog

You mean, to let the user choose a cell ? if so, use the RefEdit control, if
you mean, look at the value of the active cell, use something like

Dim MyValue As Variant

MyValue = ActiveCell.Value

--
Regards,

Juan Pablo González

"Jim McLeod" wrote in message
...
Dear group,

How is it possible to access a selected cell from a modal dialog?

Kind regards,

Jim...



Reply
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
Userform modal Dave K[_3_] Excel Discussion (Misc queries) 1 April 9th 10 07:41 AM
MS Dialog 5.0 sheets - Accessing data elements of objects Malriem Excel Worksheet Functions 2 June 4th 05 04:46 PM
Forms that are modal in 97 are not modal in 2003 Old Car Excel Discussion (Misc queries) 1 April 27th 05 08:25 AM
Controling a dialog box after I've selected the datasource JimPNicholls Excel Programming 1 December 30th 03 11:18 PM
Modal User Form Jim M[_3_] Excel Programming 1 November 4th 03 10:38 PM


All times are GMT +1. The time now is 05:43 AM.

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

About Us

"It's about Microsoft Excel"