PC Review


Reply
Thread Tools Rate Thread

combo boxes again

 
 
Atishoo
Guest
Posts: n/a
 
      12th Sep 2008
I am using a combo box to enter data into an offset cell to the active cell.
I can type free text into the combo box but cannot get it to enter when I
click the box (which activates the sub to enter the data) into the offset
cell! I suspect this is because it doesnt count this as a click event?

My sub for entering text is as follows:

Private Sub ComboBox1_Click()

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

Dim Newvalue, d
With Worksheets("Main Board")

c = .Range("D82").Value
ActiveCell.Offset(c, 0).Value = ComboBox1.Value
ComboBox1.Value = ""

End With
ComboBox1.Visible = False

Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True

End Sub

any Ideas anyone ??
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting Combo boxes to change options based on other Combo boxes. Ancient Wolf Microsoft Excel New Users 1 27th Mar 2009 06:29 PM
Parameter queries using forms with combo boxes, with select all, and defaulting combo boxes to blank fields nmoakeh@byte-x-byte.com Microsoft Access 12 15th Oct 2006 07:35 PM
Populate combo boxes from results of other combo boxes matt.pimm@gmail.com Microsoft Access Forms 1 13th Jan 2006 02:47 PM
Make combo boxes change contents depending on other combo boxes =?Utf-8?B?R2x5bm4=?= Microsoft Access Forms 1 9th Dec 2005 01:32 PM
data access page combo boxes and test boxes not visable or print =?Utf-8?B?Y3RhejJkYXk=?= Microsoft Access 0 26th Jul 2005 02:31 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:52 PM.