473,396 Members | 2,093 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Retaining values between Subs!!

AllusiveKitten
Hi

I have crated a form to appear when a word document is first opened, this form is selecting which Country's Currency I am transfering the the word document.

Form Coding::

Public Sub CommandButton1_Click()
Country = "Australia"

UserForm1.Hide
End Sub

Public Sub CommandButton2_Click()
Country = "America"

UserForm1.Hide
End Sub


My issue is that it is not retainging the value of the "Country" to tranfer to the Doucment_Open Sub inorder for my search's to run correctly.

Should all of the Sub's be private or am I completely on the wrong track.

Thank you for your assistance
AK
Sep 27 '07 #1
0 828

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Elliot M. Rodriguez | last post by:
I am not sure how to implement this. I have a DataGrid which is bound to a DataSet that the user creates by adding items from a dropdown box on my page. When the dropdownlist item is selected, a...
2
by: Mark | last post by:
Hello all - I can't seem to find what could be causing this issue so I wanted to appeal to the .NET gurus out there. When I have users input values into Page 1 and submit it, I want the ability...
2
by: cFleury | last post by:
This system works in a intranet w/ some 200 stations and this particular form is retaining its values among different stations...like if I enter some values in the form on station 1 walk to station...
2
by: cFleury | last post by:
The forms in my application are retaining the values objects have (text box, datagrid, public vars, etc…) among different computers in the network, for example if you as result of entering a...
3
by: Nick Douglas | last post by:
I have an unbound form to generate reports from in an mdb that we share on our network drive. The users selects several options for the report, such as what to view, the sort order, etc. These...
1
by: reshma | last post by:
I have one password field, confirm password field, combo box in one panel. There are 2 more panels - one for individual and another for corporate. After entering password and confirm password, i...
3
by: =?Utf-8?B?ZGVuIDIwMDU=?= | last post by:
Hi, Trouble in retaining values of dropdownlist, textboxes, and other controls when dropdownlist selectedindexchanged event is triggered, the controls are inside a user control and this user...
5
by: PokerMan | last post by:
Hi I have 6 variables that i want to keep after a postback. I have achieved it by making them static, is this correct procedure? Thanks
1
by: Anjana Bhat | last post by:
Hi, im using asp.net with c#.In my form i have a list of html radio button group in which if i select one,a text box and an image is loaded .This i have done thro. javascript.but in the same page...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.