Member Avatar for Pacman21
Pacman21 0 Light Poster

Hi All.. I am angry cause its such a little thing but its a big part of my project so Here is the scenario.. I have an access database with a table called People and a Field called Names.. In the Names field I have five entries.
A
B
C
D
E

I want to be able to have an excel macro that If Range("A1") = (Something in the Field Names) Then Range("B1") = This Person Is There.. For example: I would type in "C" at Cell A1 and I would click this button and it would say "This person is there" in cell B1.. Thanks for the responses..

  • 1 Contributor
  • 0 Replies
  • 82 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.