Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 13th 04, 04:57 PM
Mcasteel
 
Posts: n/a
Default VBA: Update worksheet when txtBox data changes.


sounds like maybe you have an .offset line that is set incorrectly, or
maybe you can correct the situation by usinga cell.offset line.

hth
M


--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698
View this thread: http://www.excelforum.com/showthread...hreadid=274237


  #2   Report Post  
Old November 13th 04, 10:16 PM
Chuckles123
 
Posts: n/a
Default


Mike,

I have the following three lines of code for a command button ("OK") in
my UserForm:

Dim Str As String
Str = txtCUT_OFF_LEVEL.Value
Level = Val(Str)

and the following two lines of code in my "main" macro:

frmCUT_OFF_LEVEL.Show (Modal)
Range("PERCENT").Value = Level

where PERCENT is a named cell (variable row location) in my workbook.
In addition, I have "Public Level As Integer" in the same module as my
"main" macro but a separate procedure by its lonely self.

I think my "one cycle delayed" updating problem is due to my Properties
not being correct for my textbox and/or my command button (less likely
to be the prob).

Chuckles123


--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948
View this thread: http://www.excelforum.com/showthread...hreadid=274237

  #3   Report Post  
Old November 14th 04, 11:59 PM
Chuckles123
 
Posts: n/a
Default


Mike,

Thru experimentation, I got it to work by deleting '(Modal)' in the
Show Form command.
Chuckles123


--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948
View this thread: http://www.excelforum.com/showthread...hreadid=274237



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
how do I make a copy of a worksheet and retain formulas but not data FireBrick Setting up and Configuration of Excel 2 December 29th 04 07:33 PM
Copy data into a NEW worksheet Krefty Excel Discussion (Misc queries) 1 December 22nd 04 01:53 PM
Reference Data in Moved Worksheet tommcbrny Setting up and Configuration of Excel 1 December 1st 04 06:49 PM
VBA: Update worksheet when txtBox data changes. Mcasteel Excel Worksheet Functions 1 November 13th 04 03:19 PM
VBA: Update worksheet when txtBox data changes. Mcasteel Excel Worksheet Functions 1 November 1st 04 06:18 PM


All times are GMT +1. The time now is 12:16 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017