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: 265
Default Default in a textbox and change a module name

2 questions:
1)
I have a form that ask the user for the bill number (a 10 numbers
number),and the user needs to type all the numbers each time that a bill is
done, so I want to use a default value in the textbox1 linked to the last
value (that is saved in a cell c5) + 1, (in cell c1 appears 0889888881 so in
the textbox appears 0889888882)
Pd. I know that this can be done automatically, but because there is some
time that bills are cancelled I need to ask the user for the bill number.
Pd2. I know that default value is an option on inputbox property, but I
cant use inputbox because my form has a lot of buttons¡¡¡¡¡¡

2)
There is some way to change the module names (instead of module1 say
easyprgms1) and also to lookup for a specific sub (because I have 100 subs
and each time I need to modify something I need to check in each of the 15
modules that I have)

Tanks for your Help

 
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
Module of VB sets as default on Excel sohraaz Excel Discussion (Misc queries) 1 July 21st 07 02:24 PM
Changing Default Module Location Ron Dahl[_2_] Excel Programming 1 October 1st 04 04:13 AM
Class module to filter textbox entry Shawn[_9_] Excel Programming 7 August 20th 04 12:53 PM
Textbox in Userform not recognised by Module SuperJas Excel Programming 5 February 26th 04 07:11 PM
set a default value on textbox Dave Excel Programming 3 February 19th 04 10:17 AM


All times are GMT +1. The time now is 10:21 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"