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: 74
Default insert alternatives combobox

Good Evening Group,

On my UserForm there is a ComboBox linked to a SpinButton by below code:

Private Sub ComboBox1_Change()

NewVal = Val(ComboBox1.Value)
If NewVal = SpinButton1.Min And _
NewVal <= SpinButton1.Max Then _
SpinButton1.Value = NewVal

End Sub

Is it possible to determine if the ComboBox value is manipulated by the
SpinButton or
if the ComboBox value has has been "manually" inserted?

Brgds

CG Rosén



 
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
Looking at alternatives Brad Excel Discussion (Misc queries) 1 September 3rd 09 05:27 PM
Indirect alternatives Brad Excel Discussion (Misc queries) 0 February 12th 09 03:32 PM
What are the alternatives ??? christopherp Excel Discussion (Misc queries) 4 March 19th 06 02:39 PM
Macros & alternatives Mangesh Yadav[_4_] Excel Programming 25 July 20th 05 10:56 AM
how do i insert a combobox in excel LYNNSKIN Excel Worksheet Functions 1 January 13th 05 08:49 PM


All times are GMT +1. The time now is 07:38 PM.

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"